QSqlTableModel submitAll access query

[wysota]

If you submit ALL, then obviously ALL rows are submitted, so the query is easy to guess. I don't really see what you're trying to do... If you want only dirty rows to be submited then simply subclass the model, store somewhere a list of dirty rows and update them manually.

[patrik08]

If you submit ALL, then obviously ALL rows are submitted, so the query is easy to guess. I don't really see what you're trying to do... If you want only dirty rows to be submited then simply subclass the model, store somewhere a list of dirty rows and update them manually.

I have two DB MYSQL connection, one db1 on Lan to fast select data 150'000 user adress 2GB data, other db2 on server outside an this db2 receive only update query.. from outside.

Model work only on db1, i can not connect model on two db connection. Also i must put on cache each query and at end sumbit all on db2.

Moreover it has also sense, to have a query log from user, to grab or discovery mistake update by so mach data.