Sorry, I didn’t notice res3 was reassigned just before the comparison. I was confused by you setting res3 = SQLITE_OK on the first line as I can see no purpose to that.
________________________________ From: sqlite-users <[email protected]> on behalf of Igor Korot <[email protected]> Sent: Monday, June 4, 2018 3:44:57 PM To: SQLite mailing list Subject: Re: [sqlite] Reset the cursor x, On Mon, Jun 4, 2018 at 9:42 AM, x <[email protected]> wrote: > int result = 0, res3 = SQLITE_OK; > for( ; ; ) > { > res3 = sqlite3_step( stmt3 ); > if( res3 == SQLITE_ROW ) > > > As I said in previous post a successful sqlite3_step doesn’t return SQLITE_OK > so > > res3 == SQLITE_ROW is never true. But SQLITE_OK != SQLITE_ROW. Thank you. > > > > > > ________________________________ > From: sqlite-users <[email protected]> on behalf > of Igor Korot <[email protected]> > Sent: Monday, June 4, 2018 3:33:54 PM > To: SQLite mailing list > Subject: Re: [sqlite] Reset the cursor > > Hi, Igor, > > On Mon, Jun 4, 2018 at 7:55 AM, Igor Tandetnik <[email protected]> wrote: >> On 6/4/2018 12:31 AM, Igor Korot wrote: >>> >>> 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. >> >> >> sqlite_reset definitely works. The problem must be somewhere in the code you >> haven't shown. Can you reproduce in a small complete example? > > Following the exact code taken from y source. > Can you spot an error? > > [code] > int result = 0, res3 = SQLITE_OK; > for( ; ; ) > { > res3 = sqlite3_step( stmt3 ); > if( res3 == SQLITE_ROW ) > { > // initial processing > } > else if( res3 == SQLITE_DONE ) > break; > else > { > // error handling > result = 1; > } > } > if( !result ) > { > res3 = sqlite3_reset( stmt3 ); > for( ; ; ) > { > res3 = sqlite3_step( stmt3 ); > if( res3 == SQLITE_ROW ) > { > // actual processing > } > else if( res3 == SQLITE_DONE ) > break; > else > { > // error handling > } > } > } > if( res3 != SQLITE_DONE ) > break; > }[/code] > > Thank you. > >> -- >> Igor Tandetnik >> >> >> >> _______________________________________________ >> sqlite-users mailing list >> [email protected] >> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ > sqlite-users mailing list > [email protected] > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ > sqlite-users mailing list > [email protected] > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
