Re: [sqlite] expression syntax

2005-01-19 Thread Paul Dixon
It worked out with pre-compiled statements (using sqlite3_bind_int). But I still wonder if there is a way to set integer values (dynamic values) into DB with INSERT and UPDATE? If you don't want to use prepared statements, I believe you can get the effect you are after with calls to

Re: [sqlite] sqlite3_busy_timeout not avoiding "database is locked" errors with multi-threaded updates

2005-01-09 Thread Paul Dixon
Stephen C. Gilardi wrote: Of course I could implement this in the application code, but I'd rather understand why sqlite isn't able to do this first. The sqlite source is unfamiliar territory, but I'll have a poke around and try to trace how the busy callback is used. Based on following the

[sqlite] sqlite3_busy_timeout not avoiding "database is locked" errors with multi-threaded updates

2005-01-07 Thread Paul Dixon
I'm having some problems with multi-threaded updates failing. Multiple threads open their own sqlite connection with sqlite3_open() and then call sqlite3_busy_timeout(handle, 3) to give a 30 second timeout. These threads then perform some inserts on the same table, but I get "database is