How to insert new record in a QSqlRelationalTableModel

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.