Re: [sqlite] Corrupted database

2009-10-14 Thread Reusche, Andrew
We get a "2" returned when we check synchronous. I think that's the enum for "full". We do not explicitely kill any threads, but when we decide to reboot or shutdown, we call "ExitProcess(0)" without stopping any DB threads, and I'm sure this isn't very healthy. Andrew This communication

Re: [sqlite] [Retrieved]Re: DB Corruption

2009-10-07 Thread Reusche, Andrew
d::char_traits,std::allocator > Andrew Reusche Software Engineer 678-297-5236 -Original Message- From: D. Richard Hipp [mailto:d...@hwaci.com] Sent: Tuesday, October 06, 2009 7:32 AM To: Reusche, Andrew Cc: General Discussion of SQLite Database Subject: Re: [Retrieved]Re: [sqlite]

Re: [sqlite] [Retrieved]Re: DB Corruption

2009-10-06 Thread Reusche, Andrew
commit anyway, or do you think that will not provide any additional benefit? Thank you for reviewing our problem! Andrew Reusche Software Engineer 678-297-5236 -Original Message- From: D. Richard Hipp [mailto:d...@hwaci.com] Sent: Monday, October 05, 2009 9:40 AM To: Reusche, Andrew Cc

[sqlite] DB Corruption

2009-10-02 Thread Reusche, Andrew
I have an issue with a sqlite3 db. I have a table that yields invalid data in some queries. Select sales.* >From sales Where sales.record_type = 1 Order By sales.datetime Desc Yields the top 124 or so records as all duplicates, and the record_type column has a "0" in each record.