Qt World Summit: Register Today!

QSqlRelationalTable does not delete row in SQLite [SOLVED]

  • It took me a day to find out and look through the QSqlTableModel source code.

    I had QSortFilterProxyModel working on a QSqlRelationalTableModel connected to a SQLite database. This database was a copy made with my own application from a MySQL database. When working on this copy SQLite database I found that the removeRows() was not working, the row was not deleted.

    After a day struggling with Signal Spy and checking my own code for the deletion of the row I found my stupid error. In the SQLite database NO PRIMARY KEYS WERE SET! Without a primary key the removeRows() does not work.

    Unfortunately this did not create an error message when debugging the application. The additional error message could be a suggestion for the developers of Qt.

Log in to reply