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 

[jacek]

What do submitAll() and lastError() return?

[JeanC]

Thanks jacek,

it's empty:

model->submitAll();
QSqlDatabase db = QSqlDatabase::database();
qDebug() << "commit" << db.lastError().text();

model->submitAll();
QSqlDatabase db = QSqlDatabase::database();
qDebug() << "commit" << db.lastError().text();

To copy to clipboard, switch view to plain text mode 

Message:

commit " "

[jacek]

Is the output the same after you change anything in the table?

[JeanC]

Ow I do this in an onclose event, the docs said it was nessecary:

QSqlDatabase db = QSqlDatabase::database();
db.close();
db.removeDatabase("iris");

QSqlDatabase db = QSqlDatabase::database();
db.close();
db.removeDatabase("iris");

To copy to clipboard, switch view to plain text mode 

[JeanC]

Yes,

First I change a cell, clik on another, changes made are still visible, then click on the menuentry for the submit call.
I noticed that when choosing OnFieldChange, if I edit a cell, then click on another, that editing is lost, so it's just not writing to the database.

Is the output the same after you change anything in the table?

[jacek]

the docs said it was nessecary:

Could you post a link? Qt should close all database connections on exit.

QSqlDatabase db = QSqlDatabase::database();
db.close();
db.removeDatabase("iris");

After you do that, you won't be able to change anything in the database.

[jacek]

First I change a cell, clik on another, changes made are still visible, then click on the menuentry for the submit call.

What happens if you press the return key before clicking anywhere?

[JeanC]

hm, it does not say it's nessecary no.

To remove a database connection, first close the database using QSqlDatabase::close(), then remove it using the static method QSqlDatabase::removeDatabase().

I guess I was begin too carefull.

[JeanC]

The field resets to what it was before.

This is with OnFieldChange

What happens if you press the return key before clicking anywhere?

[jacek]

Can you edit your database with sqlbrowser demo that comes with Qt?

[JeanC]

Well that has no QSQL driver.
But I can edit it with all other tools, query browser, phpmyadmin, own php.

[jacek]

Well that has no QSQL driver.

It should have access to the same drivers as your application.

Have you tried to change the database with QSqlQuery?

[JeanC]

It should have access to the same drivers as your application

.

I had a quick look at that code, it indeed queries for drives. Only ones it comes up with are QSQLITE, QSQLITE2 and QPSQL

Have you tried to change the database with QSqlQuery?

Gonna try that tomorrow and let you know.
Thanks for your time so far, appreciated.

[JeanC]

Yes, the same result, no error message, but no query executed either:

QString moviename = model->record(currentrow).value("name").toString();
QString querystr = "DELETE FROM pix WHERE name=";
querystr.append(moviename);
qDebug() << querystr;
QSqlQuery query(querystr);
query.exec();
qDebug() << "query" << db.lastError().text();

The output is:

"DELETE FROM pix WHERE name=ana.avi"
query " "

Have you tried to change the database with QSqlQuery?

[jacek]

QSqlQuery query(querystr);
query.exec();

This actually executes the query twice.

qDebug() << "query" << db.lastError().text();

What does qDebug() << query.lastError() output? What does db.isOpen() and db.isValid() return? Do you get any errors if you issue an invalid query? Do you start any transactions?

[JeanC]

This actually executes the query twice.

Ah thanks.

What does qDebug() << query.lastError() output? What does db.isOpen() and db.isValid() return? Do you get any errors if you issue an invalid query? Do you start any transactions?

I'm gonna investigate.
Oddity I noticed is that I can edit data with phpmyadmin, but the Mysql Query Browser has al edit options greyed out if I right click on a cell.

[JeanC]

What does qDebug() << query.lastError() output? What does db.isOpen() and db.isValid() return? Do you get any errors if you issue an invalid query? Do you start any transactions?

qDebug() << "error" << db.lastError();
qDebug() << "open" << db.isOpen();
qDebug() << "valid" << db.isValid();

Output:

error QSqlError(-1, "", "")
open true
valid true

[jacek]

but the Mysql Query Browser has al edit options greyed out if I right click on a cell.

Then maybe you don't have rights to modify the database?

[jacek]

error QSqlError(-1, "", "")
open true
valid true

And what about "query.lastError()"?