<[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Do you know a way to count the number of rows identified by a select > statement, just after the first call to sqlite3_step ? Of course > without fetching the entire result set, nor having to systematically > add count(*)
You seem to believe SQLite retrieves the whole resultset on the first sqlite3_step call. This is not the case. SQLite produces records one by one, on request, every time you call sqlite3_step. It simply doesn't know how many there are going to be, until on some sqlite3_step call it discovers there are no more. Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users