[Qt] TableView and QSqlQueryModel

[Xandareva]

Hello,
It's me again ^^ and of course I have a problem. So.. I don't know how to delete records from tableView and QSqlQueryModel. I know how get number of row which is seleted but I don't know what do after. All is ok but if I want to delete a record from tableView (and from database) then I don't know how can I do it. Now I have written add button which add new record and refresh table but I don't know how to write delete button which delete selected row.

tableView looks like:

Header: ID | NAME
1 | 23 | ASDF
2 | 52 | FDGDR

So I want to get value from column ID or something to delete row from database.

[waynew]

QSqlQueryModel is read only. You can't do dml operations with it.
Use QSqlTableModel instead.

[JD2000]

You can run a sql delete query to delete the underlying records in the database and then refresh your model.

[Xandareva]

@JD2000 yes I have this idea too but I don't know how to get value of currently selected item

[JD2000]

The sql delete command has much the same syntax as a select query.

Assuming that your table has a primary key (ID) as the first element on each row, you could try something like

QString ID = model->data(model->index(TableView->selectionModel()->currentIndex().row(),0)).toString();
QSqlQuery query;
query.prepare("SELECT FROM table WHERE id = ?"); // or SELECT * FROM
query.addBindValue(ID);
query.exec();

QString ID = model->data(model->index(TableView->selectionModel()->currentIndex().row(),0)).toString();
QSqlQuery query;
query.prepare("SELECT FROM table WHERE id = ?"); // or SELECT * FROM
query.addBindValue(ID);
query.exec();

To copy to clipboard, switch view to plain text mode 

Once you are happy that the correct row is being selected for deletion, substitute DELETE for SELECT in the above query. Please note I have not tested this but in theory it should work.

There is probably a more elegant way to do this, I'll leave that to you!

[Xandareva]

thx it works ;-)