Hi, Clemens et al, On Mon, Jun 4, 2018 at 1:23 AM, Clemens Ladisch <clem...@ladisch.de> wrote: > Igor Korot wrote: >> res = sqlite3_step( stmt ); >> >> 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. > > Strictly speaking, it is not possible to go back in the _same_ cursor. > You'd have to execute the query again (by calling sqlite3_reset() and > sqlite3_step()), and if you're not in a transaction, the data might > have been modified between these two calls. > >> 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. > > In theory, executing the same query on the same data should work again. > Did you accidentally call sqlite3_clear_bindings()?
No, I didn't clear anything. I just call sqlite3_reset() and sqlite3_step() and receive an error. Thank you. > > > Regards, > Clemens > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
