Apologies for not being too clear. Normally, I'd just query a database based on "where" criteria to get results, but that is based on a continually expanding and dynamically changing database.
In this case, I have a static (book records) database and I want to select a specific row based on the premise that I might have omitted id numbers so I cannot query the records that way. MySQL and msSql can "seek" to a specific row (line number in a database) and this must be based on some sort of database API that I am unfamiliar with and I wondered to know if there was a generic sql statement way of doing this that would work with sqlite or indeed, any database engine. > To get the row number, you just: select rowid from MyTable where > Condition; "select * from addresses where rowid=1" did the trick for me. Thank you so much for the help. Hope I can help back some day -- View this message in context: http://www.nabble.com/Go-to-specific-row-in-database-tp16367156p16367317.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
