Thursday 15 April 2010

c++ - QSqlQuery size() always returns -1 -



c++ - QSqlQuery size() always returns -1 -

qsqlquery query; qstring querytext("select * section"); query.exec(querytext); qdebug() << query.size(); //always -1 while (query.next()) qdebug() << query.value(0).tostring(); //got 16 records

method size() returns -1. help, please. thanks.

query.size() not supported sqlite. can number of rows workaround. qsqlquery::last () retrieves lastly record in result, if available, , positions query on retrieved record. after calling last() can retrieve index of lastly record , position query before first record using first() , previous() :

int numberofrows = 0; if(qry.last()) { numberofrows = qry.at() + 1; qry.first(); qry.previous(); }

c++ sql qt sqlite qsqlquery

No comments:

Post a Comment