[sqlite] 2.8 LOCK problem

2005-01-17 Thread Michael Keilhofer
Earlier I reported I was having trouble executing a statement while in a loop that performed a non-callback read of some records. Ulrik P. was nice enough to suggest opening a whole new connection. But I find that even though I do another sqlite_open() all I did was change my error from SQLITE_

Re: [sqlite] LOCK problem in 2.8

2005-01-17 Thread Michael Keilhofer
Hi Ulrik, OK, thanks. I'm having trouble ignoring the rules used with ODBC connections. Old habbits. :-) Michael Ulrik Petersen wrote: Hi Michael, Michael Keilhofer wrote: For sqlite 2.8 the documentation says that I can get a SQLITE_LOCKED when I try to execute a statement while in a cal

[sqlite] LOCK problem in 2.8

2005-01-17 Thread Michael Keilhofer
For sqlite 2.8 the documentation says that I can get a SQLITE_LOCKED when I try to execute a statement while in a callback function. I'm not using callbacks but find that when I try to do an sqlite_exec() while iterating records using sqlite_compile() and sqlite_step() I still get the SQLITE_LO

Re: [sqlite] sqlite V3 with php

2005-01-09 Thread Michael Keilhofer
Thanks! At 05:27 PM 1/9/2005, [EMAIL PROTECTED] wrote: Michael Keilhofer <[EMAIL PROTECTED]> writes: > It appears that the extension module for php 5 uses sqlite V2.8 and not V3. > > Does anyone know where there's a php extension for either php 4 or php 5 that > uses sqlit

[sqlite] sqlite V3 with php

2005-01-08 Thread Michael Keilhofer
It appears that the extension module for php 5 uses sqlite V2.8 and not V3. Does anyone know where there's a php extension for either php 4 or php 5 that uses sqlite 3? Thanks, Michael

Re: [sqlite] New to Sqlite

2005-01-03 Thread Michael Keilhofer
Brad, I found the problem and if I'd learn how to read :-) I wouldn't have sent the email. Now I know that nothing coming back means that all is OK and anything coming back means an error. Thanks, Michael At 10:31 AM 1/3/2005, Brass Tilde wrote: > My initial question is this: I have a set of SQL

[sqlite] New to Sqlite

2005-01-03 Thread Michael Keilhofer
Hello, I'm considering using Sqlite instead of Mysql on an embedded product. Since I only need straight forward INSERT, UPDATE, SELECT, and DELETE commands this seems like a reasonable alternative. Since this would be a new product, I thought I'd try to use Sqlite version 3. To evaluate the poss