EditStrategy, how to save data

[JeanC]

I'm beginning very slowly to catch some grip. Sometimes I even code more than search for things.

I can't seem to save changes in a QSqlTableModel, not if I set it to OnFieldChange and not if I set it to OnManualSubmit.
What am I overlooking?
Thanks

code:

QSqlDatabase db = QSqlDatabase::addDatabase("QMYSQL");
db.setHostName("192.168.1.10");
db.setDatabaseName("iris");
db.setUserName("jean");
db.setPassword("");
if (!db.open())
  setWindowTitle(db.lastError().text());
 
model = new QSqlTableModel;
model->setTable("pix");
model->setEditStrategy(QSqlTableModel::OnManualSubmit);
model->select();
table->setModel(model);

QSqlDatabase db = QSqlDatabase::addDatabase("QMYSQL");
db.setHostName("192.168.1.10");
db.setDatabaseName("iris");
db.setUserName("jean");
db.setPassword("");
if (!db.open())
  setWindowTitle(db.lastError().text());

model = new QSqlTableModel;
model->setTable("pix");
model->setEditStrategy(QSqlTableModel::OnManualSubmit);
model->select();
table->setModel(model);

To copy to clipboard, switch view to plain text mode