manohar s <[EMAIL PROTECTED]> wrote: > 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. Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
