[Qt-interest] QSqlQueryModel with QSortFilterProxyModel doesn'tupdate properly

Daniël de Kok me at danieldk.eu
Mon Jan 17 18:05:39 CET 2011


On Jan 17, 2011, at 5:54 PM, Scott Aron Bloom wrote:
> QSqlQueryModel does not download/receive all the matching rows at once.. what you are seeing is the effects of this...
> 
> One way to fix this is after you call setQuery (after calling query.exec() ) is to do a 
> While( model->canFetchMore() ) { model->fetchMore(); }
> 
> However, for large SQL queries this can be quite a few iterations.

Thank you! Then I'll define a regexp() user function in SQLite.

Kind regards,
Daniël de Kok


More information about the Qt-interest-old mailing list