RE: [sqlite] how to iterate on SELECT query results

2007-09-04 Thread Virgilio Alexandre Fornazin
it, a bit complicated if not). -Original Message- From: John Stanton [mailto:[EMAIL PROTECTED] Sent: terça-feira, 4 de setembro de 2007 17:17 To: sqlite-users@sqlite.org Subject: Re: [sqlite] how to iterate on SELECT query results Use sqlite3_step to read each row in sequence. Babu, Lokesh wrote

Re: [sqlite] how to iterate on SELECT query results

2007-09-04 Thread John Stanton
Use sqlite3_step to read each row in sequence. Babu, Lokesh wrote: Dear all, After doing some SELECT operation on a TABLE, say we get 100 result items out of 1000 records, Is there any way where I can iterate through this result set. i.e., Get N items out of 100, say get previous 10, get next

Re: [sqlite] how to iterate on SELECT query results

2007-09-03 Thread Trevor Talbot
On 9/3/07, Babu, Lokesh <[EMAIL PROTECTED]> wrote: > After doing some SELECT operation on a TABLE, say we get 100 result > items out of 1000 records, Is there any way where I can iterate > through this result set. i.e., Get N items out of 100, say get > previous 10, get next 10, etc, > > This