Re: [sqlite] UPDATE reports SQL logic error or missing database

2006-09-08 Thread drh
Simon Posnjak <[EMAIL PROTECTED]> wrote: > Hi again! > > I found what the problem is that sqlite returns the wrong error code. > What happens is next (in version 3.3.7): > -vdbe.c:2593 -> sqlite3BtreeCursor returns code 6 (table locked) => rc = 6 > -vdbe.c:2606 -> switch checks rc value > -vdbe.c

RE: [sqlite] UPDATE reports SQL logic error or missing database

2006-09-08 Thread Denis Povshedny
e may be an error but of course it is not a (SQL logic error or missing database) WBR, Denis -Original Message- From: Simon Posnjak [mailto:[EMAIL PROTECTED] Sent: Friday, September 08, 2006 6:02 AM To: sqlite-users@sqlite.org Subject: [sqlite] UPDATE reports SQL logic error or missing dat

Re: [sqlite] UPDATE reports SQL logic error or missing database

2006-09-08 Thread Simon Posnjak
Hi again! I found what the problem is that sqlite returns the wrong error code. What happens is next (in version 3.3.7): -vdbe.c:2593 -> sqlite3BtreeCursor returns code 6 (table locked) => rc = 6 -vdbe.c:2606 -> switch checks rc value -vdbe.c:2642 -> falls to default which is goto abort_due_to_

[sqlite] UPDATE reports SQL logic error or missing database

2006-09-07 Thread Simon Posnjak
Hi all! When I try to do UPDATE of a record i get: SQL logic error or missing database (error code 1)? The database is not missing or corrupted because I can UPDATE stuff in it with sqlite3 and I can INSERT into, SELECT from it and also DELETE. My application uses two threads. The first thread doe