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

[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

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

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

[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 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
>