Sebastian Dusza
Sebastian Dusza

Reputation: 2528

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

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

Upvotes: 5

Views: 5733

Answers (3)

Hareen Laks
Hareen Laks

Reputation: 1515

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.

Upvotes: 0

Pluto
Pluto

Reputation: 133

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;

Upvotes: 10

hmuelner
hmuelner

Reputation: 8231

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.

Upvotes: 4

Related Questions