[Qt-interest] mqsql query terminating at 100th result

[Robert Wood]

Tony Rietwyk wrote:
> Hi Robert, 
> 
> I have used QSqlQuery.exec("select * from ....") without any problems on the
> IBASE driver.  Your problem sounds like an error in the cache handling of
> your driver (was it SQLLITE?).  Suggestions: 
> 
> - Use QSqlQuery, instead of QSqlQueryModel.  
> - Use QSqlQuery setForwardOnly to disable the caching.  
> - Use a separate query "select count(*) from ...." to get the rowcount,
> instead of query.size.  
> 
> Hope that helps, 
> 
> Tony.

Hi Tony,

I'm using mysql.

Thanks for the suggestions. The only one I hadn't tried was the 
setForwardOnly option, but that makes no difference at all.

I appreciate the suggestion though.

Cheers,

Rob