deleting row from QSqlTableM​odel - not working

[sujan.dasmahapatra]

I am trying to delete a row from QSqlTableModel which is show in the QTableView but it's not working please help.




MainWindow *mainwindow; QSqlTableModel *model; QTableView *view;


model = new QSqlTableModel(this,mainwindow->db);
model->setTable("Tbl_Drawing"); model->select();
view = new QTableView;
QHeaderView *m_vert_header= view->verticalHeader();
connect(m_vert_header, SIGNAL(sectionClicked ( int ) ), this, SLOT(deleteRow ( int ) ));
view->setModel(model);
view->show();


The above way I am able to show the entries........now deleting a row like this


view->model()->removeRow(index, view->currentIndex());

But it's not removing the entry from the table..The item is still shown.....Please help me whats going wrong in this Thanks Sujan

[davidovv]

maybe you should call model->submit(), or model->submitAll();

[amleto]

oh great, another one who posts the same thing in multiple places at once.

http://www.qtforum.org/article/37876/deleting-row-from-qsqltablem%E2%80%8Bodel-not-working.html