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

Reply via email to