Update the table's ID column when you remove a row from a model.
-
When I remove a row from a table I want the ID column to be updated, that is the rows after the one deleted to have minus 1 (if can be updated when I remove multiple rows at once is even better). Does QSqlRelationalTableModel has something for updating the table's ID column or I must do that manualy?
(I also use a proxy model with QSqlRelationalProxyModel. I don't know if that is relevant).
-
I'm not quite sure about the ID you are referring to but if you are talking about the ID as a primary key (as in the relational table model) then no, there is no such functionality.
Besides that (and yes, I know this is philosopihcal question) you should never alter or reuse a primary key in a database, especially if it is auto-generated (sequenced). If you want a continous numbering of your items either use an additional column or a 'virtual' column which is created no the fly. But do not abuse your primary key for this.