Do a SELECT, read 100 rows, then read another 100. Your program
controls it.
Shailesh Madhukar Birari wrote:
> 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.
> Is this suppo
another aproach is to use OFFSET and LIMIT in your select queries:
select * from table limit 100 offset 1
then
select * from table limit 100 offset 101
then
select * from table limit 100 offset 201
etc.
Shailesh Madhukar Birari escribió:
> Does Sqlite support Paged query? what I mean is on d
"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_
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.
Is this supported in sqlite:? If yes, what are the interfaces?
If not, is there an easy way to add this functionality using existing
4 matches
Mail list logo
