x, On Mon, Jun 4, 2018 at 9:12 AM, x <tam118...@hotmail.com> wrote: > 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?
Please see the code I posted in reply to Igor's post. Thank you. > > > > ________________________________ > 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 _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
