Hi Marcelo,
It would, but I don't know the contents of the SQL at the point where I need get the row count, so I would have to scan the statement. Putting in the extra 'count(*)' all over is not really possible.
Does anyone know the timing of a sqlite3_step() compared to sqlite3_step() + sqlite_column_xxxx() ?
Leif
Marcelo Zamateo wrote:
Hi Leif:
Will "Select Count(*) from (Your_SQL)" give you what you want?
Be careful if Your_SQL includes Group By clause, don't know if work as expected.
Marcelo
