"Shailesh Madhukar Birari" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Does Sqlite support Paged query? what I mean is on doing select* it > should return me first, say 100, rows and then subsequent calls > should return me successive rows.
Do a select for all rows. Call sqlite3_step 100 times to get the first 100 rows. Continue calling it to get the rest of the rows. See also http://www.sqlite.org/cvstrac/wiki?p=ScrollingCursor Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
