Sqlite Step Back

I found that the common way for scrolling forward through a result set is using sqlite3_step(): while (sqlite3_step(statement) == SQLITE_ROW) { // do something with the row }

Solution 1:

So I was going through the functions in the sqlite3 framework since I couldn't find any documentation online and found this:

sqlite3_reset(statement)

I didn't test, but since it takes a sqlite3_stmt just like sqlite3_step() does I assume it rewinds the result set back to the beginning.