Is C1 in transaction? If it is, commit will enable C2 'see' the new table.
regards,
Radzi.
----- Original Message -----
From: "Vivien Malerba" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Friday, May 11, 2007 4:19 PM
Subject: [sqlite] Multiple connections to the same database and CREATE TABLE
command
Hi!
In a single process, I open two connections (C1 and C2) to the same
database (this is actually a corner case which could happen) and the
following sequence of operations fail:
1- on C1 execute "CREATE table actor (...)" => Ok
2- on C1 execute "SELECT * FROM actor" => Ok
3- on C2 execute "SELECT * FROM actor" => error because table "actor"
does not exist.
Is there a way to make this sequence of operations work, or should I
make sure one can never open two connections on the same DB file in
the same process?
Thanks,
Vivien
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
