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

[Rudolf Veliczky]

Hi Robert,

have you tried executing that query using Qt's sqlbrowser demo application?
Just to check that QMySQL driver works correctly or not...


Rudolf

2010/2/3 Robert Wood <robert.wood at apostrophe.co.uk>

> 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
> _______________________________________________
> Qt-interest mailing list
> Qt-interest at trolltech.com
> http://lists.trolltech.com/mailman/listinfo/qt-interest
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.qt-project.org/pipermail/qt-interest-old/attachments/20100203/fb5d7c25/attachment.html