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 10000 records then next 10000 records this way.
I planned to execute query that works on SQL ROWNUM option "select * from employee2 where rownum > 10000 and rownum < 20000" but i m getting error from sqlite3 that "no such column: rownum" Please help me to achieve "read records in chunks". I am stuck. Thanks in advance. -- Regards, - Tarun Thakur Module Lead NEC HCL System Technologies, Noida www.nechclst.in _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
