On 9 Dec 2012, at 12:44pm, dd <durga.d...@gmail.com> wrote: > Can I read the database when sqlite throws disk io or image malformed or > other critical errors first time. I cannot simulate these issues on my > machine. So, I need your suggestion.
You should not continue to work with the database in your own application on customer computers. I would recommend that you copy the database to your own computer and open it with the sqlite3 shell tool: <http://www.sqlite.org/sqlite.html> you will find a copy on every Mac in '/usr/bin/sqlite3'. You can immediately run <http://www.sqlite.org/pragma.html#pragma_integrity_check> and find out whether the error means that the file itself is corrupt. If the file fails the integrity check then the file is corrupt. if it doesn't, it means that something went wrong (software or hardware) on your customer's computer but that this didn't cause anything bad to be written to the database file. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
