Important: Please read the Qt Code of Conduct - https://forum.qt.io/topic/113070/qt-code-of-conduct
Using lastInsertId() functionality with QSqlTableModel
-
Hello,
I have a MYSQL database that I am interfacing to using the QSqlTableModel class. This is working out great except for one thing: I dont seem to have the functionality that the simpler QSqlQuery class has and that is the lastInsertId() function.
The lastInsertId function is really useful since I can get back my ID for a row I just inserted to the database.
Does anyone know of a way to get the last inserted ID using the QSqlTableModel?
Thanks,
Liz
-
I think that QSqlTableMOdel inherits form QSqlQueryModel which provides access to the QSqlQUery via the query() function. You should be able to call the lastInsertId function on the returned QSqlQuery object.
-
Yes that works. Thanks!