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] -----------------------------------------------------------------------------
