Qt and SQlite Database, How do i count queries?

Question

I've tried a lot of things.

query.isNull()

tried the query.Record() then int col = query.Record()

if I put query.size() it will return -1 even if the query has result.

How do i count queries in SQLite?

I wanted to do this:-

 if(the query returns null or empty) 
 {
  do this;
 }
  else 
 {
  do that;
 }

Are you trying to count the number of rows that will be returned without fetching them all? (You can't: the DB engine doesn't know how many there are until it gets to the end. In a complex query, this is enormously helpful.) — Donal Fellows
– Donal Fellows, Commented May 30, 2011 at 9:55

hmuelner · Accepted Answer · 2011-05-30 12:53:06Z

8

query.size() does not work with the SQlite database driver in Qt. You can do:

query.exec();
bool gotResults = false;
while (query.next()) {
  gotResults = true;
  // do something with the result using query.value(...)
}
if (!gotResults) {
  // do something else
}

answered May 30, 2011 at 12:53

hmuelner

8,2351 gold badge31 silver badges40 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Qt and SQlite Database, How do i count queries?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related