Thank you, Maybe I will just try to write a script to perform the selection. In answer to your question about '.bailing', this is a setting that can be turned on or off in the SQLite command line shell. It tells SQLite wether or not to terminate when an error is encountered.
-----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Simon Slavin Sent: Saturday, August 14, 2010 8:47 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] Database. 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 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
