SQLite: Return number of rows in a SELECT?

BlitzMax Modules Forums/Brucey's Modules/SQLite: Return number of rows in a SELECT?

Hi guys,

This may be a stupid question... but is there a way of -- for example -- doing this:

.executeQuery( "SELECT * FROM mytable" )

...and then calling something that will tell me how many rows are in the result set? I think I'm just overlooking something here, but...!

Thanks,

Boz.

Brucey

Found this on the SQLite mailing list :

> Is there any SQLite C API to find number of rows returned by select
> query?

In general, determining the number of rows is as difficult a problem as
enumerating all rows. There is no magic shortcut.

The API to find the number of rows in resultset is sqlite3_step: call it
until the resultset is exhausted, count the number of such calls.
count(*) aggregate does the same thing internally anyway.

For updates you can call the rowsAffected() method.

C64Retro

Thanks for the reply Brucey. I'm using SQLite3 for the first time (being used to MySQL) so I guess I ought to RTFM ;)

Cheers

Brucey

being used to MySQL

They are similar, but as always there are small things which you'll miss in one or the other.

I've been considering adding the pretty SQL syntax docs to the module too : http://www.sqlite.org/lang_select.html
Which might help getting to grips with the SQL side of it. (rather than having to check out the website all the time).