[Qt-interest] Does a QSqlQueryModel lock an entire sqlite database?

Paul Dixon lordelph at gmail.com
Fri May 22 10:20:52 CEST 2009


> if your table has more than 256 rows you need to call fetchMore. Sqlite
> locks the database if a query is still active.

That was it! Thanks for the tip, I'm curious to know if its documented
somewhere and I missed it ;)

Anyway, during setData I ate the remaining data with

  while (canFetchMore())
     fetchMore();


And then updates worked. Is that the most efficient workaround though?



More information about the Qt-interest-old mailing list