El Jueves, 27 de Octubre de 2005 15:44, Radu Lodina escribió: > Hi Alfredo, > > > I supose you don't use > sqlite3_get_table<http://www.sqlite.org/capi3ref.html#sqlite3_get_table>fu >nction right ? > > > Call another query with: > SELECT COUNT(*) AS NrRecords FROM ( <YOUR_ORIGINAL QUERY_STRING>) > > > Radu Lodina
I read about the sqlite3_get_table function, which the manual refers to as "really just a wrapper around sqlite3_exec()", which in turn "is just a wrapper around calls to the prepared statement interface". Since I'm using prepare, step and finalize as the recommended procedure, I thought there might be a method to get the number of rows directly. I will try the get_table funtion. Thank you. -- Alfredo J. Cole Grupo ACyC