BlankConsider doing a
SELECT COUNT (*) FROM db WHERE etc....
This should give you the number of rows before you... do the select again... Use where
to match the condition.
Tezo.
----- Original Message -----
From: Drew, Stephen
To: '[EMAIL PROTECTED]'
Sent: Wednesday, August 11, 2004 4:59 AM
Subject: [sqlite] Row Count
Hello,
Is there any way to obtain the number of rows returned by a SELECT statement, before
receiving all the rows returned? I am using the sqlite_exec() / sqlite_step()
functions to return the data, but need to populate a progress bar.
Regards,
Stephen Drew
DISCLAIMER: This e-mail and any files transmitted with it contain confidential and
proprietary information and is intended solely for the use of the intended recipient.
If you are not the intended recipient, please return the e-mail to the sender and
delete it from your computer and you must not use, disclose, distribute, copy, print
or rely on this e-mail. The contents of this e-mail and any files transmitted with it
may have been changed or altered without the consent of the author. Email transmission
cannot be guaranteed to be secure or error-free.
