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

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

To copy to clipboard, switch view to plain text mode 

[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"));

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

To copy to clipboard, switch view to plain text mode 

try this:

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

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

To copy to clipboard, switch view to plain text mode 

[raphaelf]

It works thank you