Update View when deteting record the Model

[aguleo]

Hi,
I'm using QSqlTableModel with a QTableView on Qt5.
When i delete a record ...

model->removeRows(view->currentIndex().row(), 1);

model->removeRows(view->currentIndex().row(), 1);

To copy to clipboard, switch view to plain text mode 

... i get a exclamation mark in the empty line.
I solved this by using...

model->select();

model->select();

To copy to clipboard, switch view to plain text mode 

Is this the best approach?
Showldn't the view update autommaticaly?

[aamer4yu]

Where exactly do you get the exclamation mark ? In the view ?

Also are you using QAbstractItemModel::beginRemoveRows and QAbstractItemModel::endRemoveRows while removing the rows ?

[anda_skoa]

Maybe you have to call submit() after deleting the rows?

Cheers,
_

[aguleo]

Here ... in the view:
exclamation.png

[ChrisW67]

You get the "!" in the row header indicating that the row has been scheduled for deletion. The model will not actually remove the row from the database until QSqlTableModel::submit() or QSqlTableModel::submitAll() is called on the model (depends on the model edit strategy) directly or indirectly. I suspect that if you call select() without submit() the changes are likely to be discarded not committed, but I have not done the experiment.

[aguleo]

The only way i managed to make it work was with the model.select();
I have not tried the aamer4yu's tip but, for me, the question in this point is why it worked with Qt 4 but not with Qt5!