[sqlite] Reset the cursor

[Igor Korot]

Hi, All,
After executing the following:

int res = sqlite3_prepare_v2( ... stmt );
while( ; ; )
{
    res = sqlite3_step( stmt );
    if( res == SQLITE_ROW )
    {
        // process the record
    }
    else if( res == SQLITE_DONE )
        break;
    else
    {
        // error procressing
    }
}

Now I'd like the cursor in the recordset of the "stmt" to go to the record 1
so I can process those records again.

I thought that this will be a job of sqlite_reset(), but when I called
it and started re-processing the recordset I got SQLITE_DONE on the
very first iteration.

So, how do I reset the cursor to the first record?

Thank you.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users