Important: Please read the Qt Code of Conduct -

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).

  • Database id fields do not work that way. The whole point of that field is that it does not change.

  • 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.

  • Ok, I wont modify it. I'm sorry I didn't knew that.


Log in to reply