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();

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();

To copy to clipboard, switch view to plain text mode 

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

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

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

To copy to clipboard, switch view to plain text mode 

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...t-working.html