Hi,
I have a problem editing or inserting rows in a QTableView + QSqlQueryModel.

Here my code:

Qt Code:
  1. MainDialog::MainDialog(QWidget *parent)
  2. :QDialog(parent)
  3. {
  4. ...
  5. scoopsModel = new QSqlQueryModel;
  6. scoopsModel->setQuery("SELECT numero,pagina,sottotitolo FROM elenco_scoop WHERE id_gioco="
  7. + articlesComboBox->itemData(articlesComboBox->currentIndex()).toString()
  8. + " ORDER BY numero");
  9. scoopsModel->setHeaderData(0, Qt::Horizontal, tr("Numero"));
  10. scoopsModel->setHeaderData(1, Qt::Horizontal, tr("Pagina"));
  11. scoopsModel->setHeaderData(2, Qt::Horizontal, tr("Sottotitolo"));
  12. scoopsTableView->setModel(scoopsModel);
  13. scoopsTableView->show();
  14.  
  15. connect(scoopAddButton, SIGNAL(clicked()), this, SLOT(addScoop()));
  16. ...
  17. }
To copy to clipboard, switch view to plain text mode 


Qt Code:
  1. void MainDialog::addScoop()
  2. {
  3. ((QSqlQueryModel*)scoopsTableView->model())->insertRows(((QSqlQueryModel*)scoopsTableView->model())->rowCount(), 1);
  4. }
To copy to clipboard, switch view to plain text mode 

1) First problem: if I double click a cell of a row it doesn't switch in edit mode;
2) Second problem: when clicking scoopAddButton no new row is inserted; insertRows(..) returns false.

Where is the error?

Thanks