QSqlTableModel cannot change values

[raphaelf]

Hi everybody,

I am not able to change values on my database. But i am able to see the values and change on my tableView..

Have i forgoten something?



QSqlTableModel *model = new QSqlTableModel;
model->setTable("words_tbl");
model->setEditStrategy(QSqlTableModel::OnFieldChange);
model->select();
model->removeColumn(0); // don't show the ID
model->setHeaderData(0, Qt::Horizontal, tr("Deutsch"));
model->setHeaderData(1, Qt::Horizontal, tr("Portuguiesisch"));

ui.tableView->setModel(model);
ui.tableView->show();

[darksaga]

instead of:



model->removeColumn(0); // don't show the ID
model->setHeaderData(0, Qt::Horizontal, tr("Deutsch"));
model->setHeaderData(1, Qt::Horizontal, tr("Portuguiesisch"));


try this:



ui.tableView->setColumnHidden(0, true);
model->setHeaderData(1, Qt::Horizontal, tr("Deutsch"));
model->setHeaderData(2, Qt::Horizontal, tr("Portuguiesisch"));

[raphaelf]

It works thank you :D