Save data into database

[Mr. Kibu]

Hello!

I want to whrite data into a database (SQLite).

I have got a QDialog with some QComboboxes and I want to write that data into a database (SQLite).

I have already a connection do the database, set a new QSqlRelationalTableModel with some relations and mapped that model with a QDataWidgetMapper to the QComboboxes. It works fine.

Then I have set the "setEditStrategy" of the QSqlRelationalModel to "OnManualSubmit" and added a funktion to save the data in the database (with myModel->database().commit()). It works also very fine.

The Problem:
I have got also a QCombobox in the Dialog, whose data I set after editing an other QCombobox (I want to set a correspondig default value)
The Code:

// select KsGrKey from the Source-Combo
QModelIndex id = ui->txtKsKey->model()->index(index, 6);
QString _KsGr = id.data().toString();

// set the correspondig Value of the second Combobox, that is also mapped with the model!!!
ui->txtKsGr->setCurrentIndex(ui->txtKsGr->findText(_KsGr)); //auf KsGr-Combo den Wert setzen

In the Dialog it also works fine, it shows the value in the second combobox I want to see. But when I save the data the way I have explained above (with myModel->database().commit()), the data of the second Combobox is not written into the database.

Has anybody an idea what I am doing wrong??

Thank you!

Franz

[Mr. Kibu]

Addition:

If I set a value in the corresponding Combobox by hand and save the data, than the value is written into the database as I want it.
Is the method I am using to write the value to the corresponding Combobox the right?
Is there an additional function to write the data into the database?

Thank's for help

Franz

[SGaist]

Hi and welcome to devnet,

Are you using a QDataWidgetMapper in your dialog ?

[Mr. Kibu]

@SGaist

Yes!

[SGaist]

Might be silly but did you check that the second combo box contains the right value before saving the content of your mapper ?

[Mr. Kibu]

Ok, first there was a mistake in the related datamodel of the corresponding combobox, and than there was a mistake in the submit-function. Now it works!!

Bye!