Re: [sqlite] Odd error on "BEGIN IMMEDIATE"

2007-08-18 Thread Scott Derrick
OK, I understand. Must have miss read teh docs.. thanks, Scott Trevor Talbot wrote: On 8/17/07, Scott Derrick <[EMAIL PROTECTED]> wrote: exec a "BEGIN IMMEDIATE", with a sleep loop if I can't acquire the reserved lock. Then prepare, step, finalize, exit the function When I come back

Re: [sqlite] Odd error on "BEGIN IMMEDIATE"

2007-08-17 Thread Trevor Talbot
On 8/17/07, Scott Derrick <[EMAIL PROTECTED]> wrote: > exec a "BEGIN IMMEDIATE", with a sleep loop if I can't acquire the > reserved lock. > > Then prepare, step, finalize, exit the function > > When I come back into the function and exec a "BEGIN IMMEDIATE" I get an > error > > "Cannot start a

Re: [sqlite] Odd error on "BEGIN IMMEDIATE"

2007-08-17 Thread Nuno Lucas
On 8/18/07, Scott Derrick <[EMAIL PROTECTED]> wrote: > I have a process that repeatedly, once a second, inserts data into the > database. > > I open the database, on the class instantiation. > > once a second I call a function that; > > exec a "BEGIN IMMEDIATE", with a sleep loop if I can't

[sqlite] Odd error on "BEGIN IMMEDIATE"

2007-08-17 Thread Scott Derrick
I have a process that repeatedly, once a second, inserts data into the database. I open the database, on the class instantiation. once a second I call a function that; exec a "BEGIN IMMEDIATE", with a sleep loop if I can't acquire the reserved lock. Then prepare, step, finalize, exit the