I am trying to determine before a query is executed how many rows will be returned. the following query works as expected
select count(*) from table but select count(*) from table limit 100 still returns the number of rows in the table not the number of rows that would be returned by the query. is this operation correct? I can of course parse the query to determine any limit on what will be returned, but wondered if this is a bug or a design feature. Paul www.sandersonforensics.com skype: r3scue193 twitter: @sandersonforens Tel +44 (0)1326 572786 http://sandersonforensics.com/forum/content.php?195-SQLite-Forensic-Toolkit -Forensic Toolkit for SQLite email from a work address for a fully functional demo licence