Hi There After executing a query I get the result back and can traverse it using sqlite3_step. This is fine for most systems, however for what I wish to use SQLite for, I would need something similar to stepForward, stepBackward, stepToFirst, stepToLast.
The application where I'm going to use it is when showing a list items from a database table in a window. If the window can display 5 items, there is no need to load more than 5 rows in the beginning. Here sqlite3_step is sufficient. But if the users press up arrow, it should take them to the bottom of the list, and I would like to use something similar to setToLast. If the user keep pressing up, I would need to stepBackward. I know this might not be something for the sqlite database. How would you go about wrapping this interface? I know it is a broad question and your suggestion is very much appriciated! :) Cheers Kim B.
