Reading data after submit returns wrong values

Mark81

This is my actual code:

void DialogEdit::saveBoard(int *row, int *id)
{
    *row = _modelBoards->rowCount();
    qDebug() << _modelBoards->insertRow(*row);
    qDebug() << _modelBoards->setData(_modelBoards->index(*row, MODEL_BOARDS_COL_NAME), ui->txtName->text());
    qDebug() << _modelBoards->setData(_modelBoards->index(*row, MODEL_BOARDS_COL_DESC), ui->txtDesc->text());
    qDebug() << _modelBoards->submitAll();
    qDebug() << _modelBoards->select();

    *id = _modelBoards->data(_modelBoards->index(*row, MODEL_BOARDS_COL_ID)).toInt();
    Q_ASSUME(*id > 0);
}

The model is an QSqlTableModel with the edit strategy set to OnManualSubmit.
Sometimes, it happens that id is read as 0, while in the database has the correct value (id INTEGER PRIMARY KEY).
All the methods return true - I can see the correct value in the db (using DB Browser for SQLite).

As far as I understand select() is a syncrhonous function, so when it returns the model should be already update.
Is there anything other I need to do before read the data?

Qt 5.12.5 under Win7

SGaist

Hi,

Since it's "sometimes", did you determine if that happens when your system is under pressure doing some heavy tasks ?

Mark81

@SGaist Unfortunately I didn't find any criteria. I'm just developing with QtCreator.

SGaist

Does it also happen if you put the database in memory ?