How to get total number of rows/records in an sqlite table

Question

i want to know how to get the total number of rows/records in an sqlite table and assign it to a variable. I did this;

    QSqlQuery query("SELECT COUNT(*) FROM class1_bills");

But the problem is, how do i assign the result to a variable? I tried;

int rows = query.seek(0);

and;

int rows = query.value(0).toInt();

Yes, I know doing that accesses just the record at field position 0 in the table. But it seems Qt's query methods are for accessing particular records at field positions only. If i'm wrong please correct me. So how do i get the total row count in the table?

possible duplicate of QSqlQuery how to get value of a count? — m.s.
– m.s., Commented Apr 22, 2015 at 16:02

CL. · Accepted Answer · 2015-04-22 20:38:44Z

6

The query returns a single column and a single row.

Just read that value:

query.first();
count = query.value(0).toInt();

edited Apr 22, 2015 at 20:38

answered Apr 22, 2015 at 16:06

CL.

182k18 gold badges241 silver badges282 bronze badges

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

1 Comment

ahmed Over a year ago

If you pass a query to QSqlQuery constructor it will be executed, no need to call exec()

ahmed · Accepted Answer · 2015-04-22 16:06:56Z

-1

It's simple, just like any other query:

int rows = 0;
QSqlQuery query("SELECT COUNT(*) FROM class1_bills");
if (query.next()) {
    rows = query.value(0).toInt();
}
// Do something with rows

answered Apr 22, 2015 at 16:06

ahmed

5,6001 gold badge23 silver badges38 bronze badges

Collectives™ on Stack Overflow

How to get total number of rows/records in an sqlite table

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related