Thanks Igor. Yup, it's corrupt. I had already suspected as much so I started writing a little program to read everything and copy to a new database to save what I can. Is there a better way to try and repair?
Corey On Sun, Jul 8, 2012 at 5:34 PM, Igor Tandetnik <[email protected]> wrote: > Corey Nelson <[email protected]> wrote: > > sqlite> DELETE FROM GBP_CHF_BID WHERE price LIKE "12.%"; > > sqlite> SELECT * FROM GBP_CHF_BID WHERE price LIKE "12.%"; > > 1294352100000|12.0169 > [more results snipped] > > I'd suspect a corrupted database. Run PRAGMA integrity_check; , see what > it says. > -- > Igor Tandetnik > > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
