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

Jan janusius at gmx.net
Fri May 22 10:31:29 CEST 2009


yes, it's documented (somewhere) :-)

Paul Dixon schrieb:
>> 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?
> _______________________________________________
> Qt-interest mailing list
> Qt-interest at trolltech.com
> http://lists.trolltech.com/mailman/listinfo/qt-interest
> 



More information about the Qt-interest-old mailing list