Re: [sqlite] Number of rows in a query result

2005-10-27 Thread Alfredo Cole
El Jueves, 27 de Octubre de 2005 15:44, Radu Lodina escribió: > Hi Alfredo, > > > I supose you don't use > sqlite3_get_tablefu >nction right ? > > > Call another query with: > SELECT COUNT(*) AS NrRecords FROM ( ) > > > Radu Lodina

Re: [sqlite] Number of rows in a query result

2005-10-27 Thread Radu Lodina
Hi Alfredo, I supose you don't use sqlite3_get_tablefunction right ? Call another query with: SELECT COUNT(*) AS NrRecords FROM ( ) Radu Lodina On 10/28/05, Alfredo Cole <[EMAIL PROTECTED]> wrote: > > Hi: > > In order to update a progres

[sqlite] Number of rows in a query result

2005-10-27 Thread Alfredo Cole
Hi: In order to update a progress bar, I need to know the total number of rows returned by a query, similar to MySQL's mysql_num_rows. Is there a function like that in the C API? I may have overlooked it, but have not found it so far. Thank you. -- Alfredo J. Cole Grupo ACyC