pass variable from tab to dialog

[SGaist]

Hi,

Where's the data coming from ?

[TheCipo76]

from database
i had put it in different combobox as you see in the picture:
LAVORAZIONE, MACCHINA, PZORA

now i want populate tableview (with abstracttablemodel i think)
on "Aggiorna" click

from tabcomplessivo (0059.0430)-> to dialog
from tabcomponente (0040.0153/0065.0040/0065.0041/0065.0042/0065.0043)-> to dialog

[mrjj]

Hi
If you make a model with data from the database, and then use
http://doc.qt.io/qt-5/qdatawidgetmapper.html
to hook up the combo boxes, you can then hook up tableview to same model
and it should automatically update when user select new data in tabcomplessivo etc.

I asume you did see
http://doc.qt.io/qt-5/qsqltablemodel.html
but it didnt fit your use case. (being single table ) ?

[TheCipo76]

@mrjj
the comboboxes was populated from different databases

tableview in only a preview of data

on "Registra" click i will store the data from tableview to another database

qdatawidgetmapper is very interesting but i'm not sure this is my way.

Any suggestions?

[mrjj]

@TheCipo76
Hi
Does the data from tableview live in one table or across multiple tables ? ( mean when saved to db)

[TheCipo76]

@mrjj i have to save the tableview data in only one database

[mrjj]

@TheCipo76
and in this context, one database is one table ?
Im asking as you could use QSqlTableModel
and write the data from the comboboxes to
the model and view ould just show it. ( and be saved)
https://stackoverflow.com/questions/47318601/inserting-row-into-qsqltablemodel

[TheCipo76]

@mrjj sorry.. yes is only one table in the same database

i'm already using QSqlTableModel in my app

but if i use QSqlTableModel for the tableview the data was stored immediately on the database..

instead i want only populate it with comboboxes (to generate a preview)
and then store the data only with "Registra" click (after that i have checked input by code)..

all to prevent duplication, error and other problem that can be created by users input.

[mrjj]

@TheCipo76
Ah, i assumed user could only select valid data from the combo boxes.
But you could change
QSqlTableModel::setEditStrategy() to QSqlTableModel::OnManualSubmit
check the model from code and do
QSqlTableModel::submitAll() to save to db.
?

[TheCipo76]

@mrjj how can i access to tabs comboboxes data from mainwindow??

i've declarated in .h file like "public" all the comboboxes (in all the tab forms)

when i click "Aggiorna" i want to read all comboboxes of all tabs (with 2 nidificated loop: 1 for all tab, and inside the first, 1 for all comboboxes of each tab) and populate the qsqltablemodel (tableview) in mainwindow form

i'm trying to store all data in some QString before to insert in model

i've tried with this code:

Lavorazione = tabcomplessivo::array_Lavorazione[j]->currentText();

but i have this error:

invalid use of non-static data member 'array_Lavorazione'

[mrjj]

@TheCipo76

Hi
The syntax you are using would mean a static variable. ( hence the error)
You need a pointer to the dialog. ( i assume the combobox are in other dialog ? )
dialogptr->tabcomplessivo->array_Lavorazione[j]->currentText();

Often you would do it same place where you show dialog
like
TheDialog dia; // we dont need to NEW it as we use exec() which blocks.
if(dia.exec() == QDialog::Accepted)
{
// grab the data
dia.tabcomplessivoPtr.array_Lavorazione[j]->currentText();
...
}

[SGaist]

Are you only preparing the data to be stored in the database or will you also be showing entries from the database in that table view ?

[TheCipo76]

@mrjj
as you can see in the first post isn't a dialog but
tabcomplessivo and tabcomponente were
simple forms pass like tabs to tabwidget

[mrjj]

@TheCipo76
So they are actual inside the mainwindow ?

[TheCipo76]

@mrjj Yes

[TheCipo76]

@SGaist only prepare a preview
then (on "Registra" click) it will be stored in db

otherwise the tableview need filter in order to don't show (and modify) other data (item) in the table

both case is good however

[SGaist]

In that case, wouldn't it be easier to use a QTableWidget to setup the rows and then QSqlQuery to update your database when you click on Registra

[TheCipo76]

@SGaist yes but i can't access to data in tabcomplessivo and tabcomponente
as i've already wrote up they were in the mainwindow and declared pulic

[SGaist]

Just to be sure, do you have several different widgets that you built with designer and that you are putting together in that dialog ?

[TheCipo76]

@SGaist i've two different forms (but similar 90%)
n.1 tabcomplessivo
some tabcomponente
all in the mainwindow

i've created with designer and added to tablewidget with code (first post) and populated dinamically with different table (from database) with different query

i have always only one tabcomplessivo and some (depends by item in database)
tabcomponente

complessivo = componente + componente +... + componente
i hope that's clear (my english is not very good..)

i have to describe all operations on every componente to build one complessivo