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

Reply via email to