Re: [sqlite] SQL ROWNUM option is failed - Want to Read records in chunks from table

On Fri, Aug 26, 2011 at 12:50:36PM +0530, Tarun scratched on the wall: > Hi, > > I am calling sqlite3_get_table() to execute query to read all records > from table but issue is records can be many lacs so result set in char > **result may not be able to contain that large number of records. So i

Re: [sqlite] SQL ROWNUM option is failed - Want to Read records in chunks from table

> Tarun writes: […] > I planned to execute query that works on SQL ROWNUM option > "select * from employee2 where rownum > 1 and rownum < 2" Perhaps: SELECT * FROM employee2 ORDER BY oid LIMIT 1 OFFSET 1 > but i m getting error from sqlite3 that "no such

[sqlite] SQL ROWNUM option is failed - Want to Read records in chunks from table

Hi, I am calling sqlite3_get_table() to execute query to read all records from table but issue is records can be many lacs so result set in char **result may not be able to contain that large number of records. So i wanted to read records in chunks like first 1 records then next 1 records