TableView + SqlQueryModel: can't insert or edit rows

[jiveaxe]

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

Here my code:


MainDialog::MainDialog(QWidget *parent)
:QDialog(parent)
{
...
scoopsModel = new QSqlQueryModel;
scoopsModel->setQuery("SELECT numero,pagina,sottotitolo FROM elenco_scoop WHERE id_gioco="
+ articlesComboBox->itemData(articlesComboBox->currentIndex()).toString()
+ " ORDER BY numero");
scoopsModel->setHeaderData(0, Qt::Horizontal, tr("Numero"));
scoopsModel->setHeaderData(1, Qt::Horizontal, tr("Pagina"));
scoopsModel->setHeaderData(2, Qt::Horizontal, tr("Sottotitolo"));
scoopsTableView->setModel(scoopsModel);
scoopsTableView->show();

connect(scoopAddButton, SIGNAL(clicked()), this, SLOT(addScoop()));
...
}



void MainDialog::addScoop()
{
((QSqlQueryModel*)scoopsTableView->model())->insertRows(((QSqlQueryModel*)scoopsTableView->model())->rowCount(), 1);
}

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

[janus]

Hi,

I guess you need a QSqlTableModel. QueryModel is read only, I suppose.

[jiveaxe]

Why list this function among QSqlQueryModel's members if it doesn't work?

Regards

[jacek]

Why list this function among QSqlQueryModel's members if it doesn't work?
QSqlQueryModel docs don't list it. This method exists, because it was inherited from QAbstractItemModel.