On 13 Aug 2010, at 7:45pm, Kirk Clemons wrote: > Is there a way to parse my database by row id? In other words incase there is > an error I don't want SQLite stop parsing. I have bailing turned off
What is 'bailing' ? > but it still does not continue on through the database when doing a 'select > *' on each row. The row ids can be addressed as the column "_rowid_" even if you didn't define such a column yourself. So you can do things like SELECT * FROM myTable WHERE _rowid_ = 100; SELECT * FROM myTable WHERE _rowid_ = 101; SELECT * FROM myTable WHERE _rowid_ = 102; But your question suggests you're dealing with a corrupt database. The SQLite functions rely on the database being uncorrupted for pretty-much everything: any corruption in your database can cause any of the functions to give wrong results. The only safe attitude to have is that as soon as you know your database is corrupt you trash it and restore a backup. If you want the experts (the people who know /everything/ about SQLite) to piece though it and rescue everything possible, contact hwaci http://www.hwaci.com/sw/sqlite/prosupport.html#rescue and pay what they ask. For a simple job with no huge time-pressure, it shouldn't be too expensive. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
