SQLite is a relational database. Relations are unordered sets so SQL, which SQLIte uses, doesn't have any operators to move backwards and forwards.
With a relational database you should number your records in some way and then your application asks for the appropriate records by number, so if you're looking at Question 23 and you want to page backwards, your application must ask SQLite for Question 22. -- View this message in context: http://www.nabble.com/how-to-move-backward-and-forward-in-sqlite--tp25702963p25710367.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
