QSqlTableModel::removeRow() does not delete row in SQLite database

Question

I use Windows, C++ and Qt 5.11.1. I have a simple single-table SQLite database. This table "templates" contains primary key: id INTEGER PRIMARY KEY.When I try to remove a single row in "templates" (using QSqlTableModel), m_model.removeRow(0) returns true and submitAll() returns true. But the table still owns that row. I've found that Qt generated the following SQL:

DELETE FROM templates WHERE "templates"."id" IS NULL.
I suppose that the problem is linked with QSqlRecord::isGenerated. How can I fix this error?

score 3 · Accepted Answer · answered Nov 07 '18 at 07:08

3

As QSqlTableModel::removeRows documentation :

Deletions are submitted immediately to the database. The model retains a blank row for successfully deleted row until refreshed with select().

answered Nov 07 '18 at 07:08

Kerem

85
1
11

I didn't use `select()`. I will add it. But I re-opened the database file (sometimes with 3rd party GUI tool) - no modifications were found. So the SQL query is invalid. – ilya Nov 07 '18 at 08:08

score 0 · Answer 2 · answered Nov 08 '18 at 06:12

0

Sorry, the reason was in overriden data() method in QSqlTableModel descendant. record() method required data(index, Qt::EditRole).

answered Nov 08 '18 at 06:12

ilya

1,103
14
36

QSqlTableModel::removeRow() does not delete row in SQLite database

2 Answers2