I am trying to alter the dump function of the command line shell. I am not completely familiar with C Programming so I am sort of in the dark here. As I understand it's workings now the .dump command performs a 'select *' on each row in row id order. If it encounters an error it skips to the end of the database and takes each row in reverse order. This means I get all the information before and after any errors.
This is great but ideally I would want any data in between as well. If I have a database with 100 rows and row 2 and 99 are corrupt but everything in between is fine I lose my entire database when I call the dump command. I would like to be able to tell SQLite that if line 2 is bad just skip to line 3 and so on until the database has been parsed all the through maximizing the amount of data I retain. Regards, ~Kirk. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
