Re: [sqlite] Database Corruption - Table data being overwritten

2012-06-06 Thread Black, Michael (IS)
base Corruption - Table data being overwritten Hello, I have run into a problem using SQLite in an embedded environment. Currently using version 3.7.5. (I know, I want to update, just have been locked in at this version for the time being) The power is routinely cut from the system, so I ha

Re: [sqlite] Database Corruption - Table data being overwritten

2012-06-06 Thread Simon Slavin
On 6 Jun 2012, at 1:03pm, herb...@gdls.com wrote: > Even more bizarre, a .dump of "table1" will show: > INSERT INTO "table1" VALUES(28274, 6, 10308); > > But this query returns nothing: > SELECT * FROM table1 WHERE table1_id=28274; There should be (at least) two copies of that number in the d

[sqlite] Database Corruption - Table data being overwritten

2012-06-06 Thread herbstp
Hello, I have run into a problem using SQLite in an embedded environment. Currently using version 3.7.5. (I know, I want to update, just have been locked in at this version for the time being) The power is routinely cut from the system, so I have JOURNAL_MODE = PERSIST because there were issu

Re: [sqlite] Database Corruption - Table data being overwritten

2012-06-06 Thread Richard Hipp
On Wed, Jun 6, 2012 at 8:03 AM, wrote: > Hello, > > I have run into a problem using SQLite in an embedded environment. > > Currently using version 3.7.5. (I know, I want to update, just have been > locked in at this version for the time being) > > The power is routinely cut from the system, so I

[sqlite] Database Corruption - Table data being overwritten

2012-06-06 Thread herbstp
Hello, I have run into a problem using SQLite in an embedded environment. Currently using version 3.7.5. (I know, I want to update, just have been locked in at this version for the time being) The power is routinely cut from the system, so I have JOURNAL_MODE = PERSIST because there were issu