How to insert new record in a QSqlRelationalTableModel

[Panoss]

Yes, it is: mapper->submitPolicy= QDataWidgetMapper::AutoSubmit

[SGaist]

What happens if you manually call submit on the mapper ?

[Panoss]

The same: a new record is created but only the autoincremented field is filled, the others are empty, null.
I tried mapper->submit() and model->submitAll().

Maybe it's because mapping is happening in the constructor of the form? And the controls on the form have not yet been fully created?

[SGaist]

Are you sur the mapper is valid ?
Why is it not part of your dialog rather than passed around ?

[Panoss]

The mapper is created in the parent form.
It 's passed to the child (addArticle).
I want to use it in the child for inserting a new record.

How can I check if it's valid?

[SGaist]

Check the current index.

[Panoss]

mapper 's currentIndex works ok, so I guess the mapper is valid.

[Christian Ehrlicher]

Your record is empty - so what's your db structure. Does it allow NULL values, has it a PK?

[Panoss]

The table does have a primary key.
The record gets inserted in the database, so I guess it allows NULL values.

[Christian Ehrlicher]

This post is deleted!

[gillranjeett]

I want to use it in the child for inserting a new record. mx player for pc mxplayer

[SGaist]

The logic should be the other way around.
Use the dialog to get the data from your application user. Then create the record based on the data you extract from the dialog.
This will also allow you to properly handle cancellation of the dialog. Otherwise you may end up with empty rows in the database that you will need to remove because you added it too early in your business logic.

[Panoss]

@SGaist said in How to insert new record in a QSqlRelationalTableModel:

Use the dialog to get the data from your application user. Then create the record based on the data you extract from the dialog.

I 'll do it this way.