Hello again, I would like to select a row in the a QTableView after inserting it to database using QSqlQuery. . I can see the added row in QTableView but my problem is I cannot find QModelIndex which corresponds to the new row in the model. And i use QSortFilterProxyModel between the model and the view.

How can i find QModelIndex of the inserted row and select it in QTableView?

Qt Code:
  1. modelt = new QSqlTableModel(this);
  2. modelt->setTable("sianimtable");modelt->setEditStrategy(QSqlTableModel::OnRowChange);
  3. modelt->setHeaderData(1, Qt::Horizontal, "Code");
  4. modelt->setHeaderData(3, Qt::Horizontal, "Name);
  5. modelt->select();
  6.  
  7. filterModel = new QSortFilterProxyModel;
  8. filterModel->setSourceModel(modelt);
  9. filterModel->setFilterKeyColumn(2);
  10.  
  11. QTableView* view = new QTableView;
  12. view->setModel(filterModel);
  13. view->resizeColumnsToContents();
  14. view->horizontalHeader()->setStretchLastSection(true);
  15. view->setSelectionBehavior(QAbstractItemView::SelectRows);
  16. view->setSelectionMode(QAbstractItemView::SingleSelection);
  17. view->setEditTriggers(QAbstractItemView::NoEditTriggers);
  18. view->hideColumn(0);
  19. view->hideColumn(2);
  20. view->hideColumn(4);
  21. view->hideColumn(5);
  22. view->hideColumn(6);
  23. view->setSortingEnabled(true);
  24. view->sortByColumn(1, Qt::AscendingOrder);
  25. view->verticalHeader()->hide();
  26. view->setAutoScroll(true);
To copy to clipboard, switch view to plain text mode 

Inserting with:
Qt Code:
  1. QSqlQuery *q = new QSqlQuery();
  2. q->prepare("INSERT INTO sianimtable (CIPHER,CIPHERKP,TITLE,MSGON,MSGOFF) VALUES(:le2,:le1,:le3,:le4,:le5);");
  3. q->bindValue(":le1",le1->text());
  4. q->bindValue(":le2",le2->text());
  5. q->bindValue(":le3",le3->text());
  6. q->bindValue(":le4",le4->text());
  7. q->bindValue(":le5",le5->text());
  8.  
  9. if(q->exec()==false)
  10. {
  11. QMessageBox *pmsg = new QMessageBox;
  12. pmsg->setText("Can't connect");
  13. pmsg->setInformativeText(q->lastError().text());
  14. pmsg->exec();
  15. }
  16. delete q;
To copy to clipboard, switch view to plain text mode