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 <itandet...@mvps.org> wrote: > Corey Nelson <corey.nel...@gmail.com> 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 > 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