Re: "The Database File Is Locked" sqlite

2013-08-29 Thread Peter Haworth
Hi Mike, Can happen if you issue a BEGIN without a corresponding COMMIT or ROLLBACK, then issue another BEGIN. Also, if by some chance you're using an admin tool that has the db locked for some reason. I've never used an sqlite db over a network connection but I've read that locks don;t work very

"The Database File Is Locked" sqlite

2013-08-29 Thread Mike Kerner
How the heck can a single-threaded environment like LC create this error? I have a series of queries that hit sqlite, followed by UPDATE x SET y = 0 WHERE y = 1 which results in this error. -- On the first day, God created the heavens and the Earth On the second day, God created the oceans. On t