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()? Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
