SQLite use the 'cursor' style like SQL Server / ORACLE in stored procedures:
you fetch in a unidirectional (forward only) way. 

To achieve bi-directional support you must have to store the results in
memory as you fetch them (not so difficult to accomplish if you have enough
memory to do 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:
> 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 10, etc,
> 
> This should be done without creating a temporary table or virtual
> tables. As there is overhead of space and time.
> 
> If it is possible to use VIEWs then how can I? As I think VIEWs are
> little better than temp table or virtual table. Please correct me if
> I'm wrong.
> 
> please reply, thanks in advance.
> 
>
----------------------------------------------------------------------------
-
> To unsubscribe, send email to [EMAIL PROTECTED]
>
----------------------------------------------------------------------------
-
> 


----------------------------------------------------------------------------
-
To unsubscribe, send email to [EMAIL PROTECTED]
----------------------------------------------------------------------------
-


-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------

Reply via email to