Re: [sqlite] Go to specific row in database

2008-03-28 Thread flakpit
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 p

Re: [sqlite] Go to specific row in database

2008-03-28 Thread BareFeet
Hi flakpit, > MySql and msSql have seek commands to go to a( or return) a specific > row in a database base don the internal row number rather than an id > or other identifier. > > Is there a generic SELECT statement that can do this for sqlite or > indeed, any other sql variant? SQL is (of

[sqlite] Go to specific row in database

2008-03-28 Thread flakpit
MySql and msSql have seek commands to go to a( or return) a specific row in a database base don the internal row number rather than an id or other identifier. Is there a generic SELECT statement that can do this for sqlite or indeed, any other sql variant? Regards. -- View this message in conte