On 9/11/2012 7:28 PM, Arbol One wrote:
This works just fine, but it only reads the first row
Of course. You only ever call sqlite3_step step after prepare and before finalize.
how can I 'tell' my program HOW MANY rows are there to be read and which row I WANT TO READ?
You are supposed to call sqlite3_step repeatedly, for as long as it returns SQLITE_ROW. Every call fetches a new row. When sqlite3_step returns SQLITE_DONE, there are no more rows.
-- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
