QtSQL + Sqlite and support for .size() function?

Question

I'm wondering does QtSql + Sqlite support QSqlQuery::size() function?

I know its not supported. Maybe there is an alternative driver for QtSql that supports it ? — Sebastian Dusza, Mar 21 '11 at 16:06
I don't think so, because the SQlite API does not provide this information (see http://winmerge.org/ and http://sqlite.org/c3ref/step.html) — hmuelner, Mar 21 '11 at 17:04
True, C/C++ API doesn't provide it. But look -> http://php.net/manual/en/function.sqlite-num-rows.php . How can PHP folks do it, if its not possible ? :-) — Sebastian Dusza, Mar 21 '11 at 19:01

score 10 · Answer 1 · answered Oct 27 '12 at 13:41

10

No, it doesn't. However, you can use last() and at() together to get the result.

QSqlQuery q;
q.exec("select * from table");
q.last();
qDebug() << q.at() + 1;

answered Oct 27 '12 at 13:41

Pluto

133
1
5

score 4 · Accepted Answer · edited May 23 '17 at 12:18

4

No, it does't. SQLite is one of the databases for which the size of the query is not directly available. BTW: A Google-query for "qt sqlite QSqlQuery size" had this StackOverflow question as first answer.

edited May 23 '17 at 12:18

Community

1
1

answered Mar 21 '11 at 15:32

hmuelner

8,093
1
28
39

Well I googled it for a while and couldn't find anything precise. Anyway thx for answer. Franky I think its strange, sqlite api for PHP has num_rows function. – Sebastian Dusza Mar 21 '11 at 16:05
1

I ran that search today and first result was for *this* question. – Antonio Pérez Sep 15 '15 at 11:05
Thanks for this info :-) – hmuelner Sep 17 '15 at 09:36

score 0 · Answer 3 · answered May 03 '13 at 04:37

I also faced the same issue with SQLite and Qt.

As a solution I used

if (query.next())
{
}

to identify the query returns values or not.

But be careful it directs you to the first record. And if you need the no of records exactly, then this is not a solution.

QtSQL + Sqlite and support for .size() function?

3 Answers3

Linked