Sorry, just looked that up. 1 is SQLITE_ERROR. 100 is SQLITE_ROW
But note that a successful sqlite3_step does not return SQLITE_OK (0). Are you maybe converting the result to Boolean? ________________________________ From: sqlite-users <sqlite-users-boun...@mailinglists.sqlite.org> on behalf of Igor Korot <ikoro...@gmail.com> Sent: Monday, June 4, 2018 1:52:05 PM To: SQLite mailing list Subject: Re: [sqlite] Reset the cursor Hi, On Mon, Jun 4, 2018 at 7:54 AM, Igor Korot <ikoro...@gmail.com> wrote: > 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. In addition: As I said calling sqlite3_step() after sqlite3_reset() returns 1 (error). However calling sqlite3_errcode() right after returns 0 (which is success, right) Thank you. > > 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 _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users