Re: [sqlite] No info on DEFERRED, IMMEDIATE, and EXCLUSIVE transactions

2004-10-23 Thread Tito Ciuro
Thanks a lot Tiago! -- Tito On 23 oct 2004, at 23:30, Tiago Dionizio wrote: I believe this is what you are looking for: http://www.sqlite.org/lang.html#transaction Tiago On Sat, 23 Oct 2004 22:50:36 +0200, Tito Ciuro <[EMAIL PROTECTED]> wrote: Hello, Sorry to post the question again, but after

Re: [sqlite] No info on DEFERRED, IMMEDIATE, and EXCLUSIVE transactions

2004-10-23 Thread Tiago Dionizio
I believe this is what you are looking for: http://www.sqlite.org/lang.html#transaction Tiago On Sat, 23 Oct 2004 22:50:36 +0200, Tito Ciuro <[EMAIL PROTECTED]> wrote: > Hello, > > Sorry to post the question again, but after reading the "File Locking > And Concurrency In SQLite Version 3"

[sqlite] problem with SELECT * when using multiple FROM tables

2004-10-23 Thread Radek Hulán
When working on a DB layer, and migrating a project from MySQL to SQLite, I've noticed that this is ok with MySQL: CREATE TABLE b ( afield1 integer, afield2 integer); CREATE TABLE b ( bfield1 integer, bfield2 integer); $query = sqlite_query('SELECT * FROM a, b WHERE afield1=bfield1',$db);

[sqlite] No info on DEFERRED, IMMEDIATE, and EXCLUSIVE transactions

2004-10-23 Thread Tito Ciuro
Hello, Sorry to post the question again, but after reading the "File Locking And Concurrency In SQLite Version 3" page (http://www.sqlite.org/lockingv3.html), I still haven't been able to locate info on DEFERRED, IMMEDIATE, and EXCLUSIVE transactions. Could someone please explain the

Re[2]: [sqlite] PHP 5.0.2 / Win sqlite_query problem

2004-10-23 Thread Bertrand Mansion
Radek Hulán wrote: >>> When I try to execute the same query using sqlitecc.exe it works just fine. >>> > >DRH> This fact suggests that the problem is in PHP or the application program, >DRH> not in SQLite. > >There can hardly be any problem with sqlite_query($db,$query) application >code... Is