Does QDataWidgetMapper lock sqlite and prevent write by other applications?

[Al_]

Hi all

I found a work-around: prefetch the entire table. Obviously, this is only feasible for small database tables (small compared to available memory).

Add the following statement after select()'ing the model (i.e., after line 42 in my example)

while (model->canFetchMore()) model->fetchMore();

while (model->canFetchMore()) model->fetchMore();

To copy to clipboard, switch view to plain text mode 

[anda_skoa]

Another option would be to implement your own QAbstractTableModel subclass and use QSqlQuery internally.

Since you know which database you are using, this model might even use database specific features, e.g. paging.

Cheers,
_