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

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

Hello Simon! Just for your information. I have often receive this error (SQL logic error or missing database) when some constraints failed or keys aren't unique. I use 3.3.4; earlier with version 3.2.8 I had correct responses for non-uniqueness failures. So I think when you update data there may b

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

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_