Re: [sqlite] Read and write in SQLite

2007-11-09 Thread Trevor Talbot
On 11/9/07, Joanne Pham <[EMAIL PROTECTED]> wrote: > I have an application to writh to database with begin transaction and end > transaction. > Before end transaction another application try to connect to the database to > read the data and in the middle of the read of the second application > t

Re: [sqlite] Read and write in SQLite

2007-11-09 Thread Joanne Pham
lbot <[EMAIL PROTECTED]> To: sqlite-users@sqlite.org Sent: Friday, November 9, 2007 1:43:26 PM Subject: Re: [sqlite] Read and write in SQLite On 11/9/07, Joanne Pham <[EMAIL PROTECTED]> wrote: > I knew that SQLite doesn't allow concurrency for both read and write at the > sam

Re: [sqlite] Read and write in SQLite

2007-11-09 Thread Trevor Talbot
On 11/9/07, Joanne Pham <[EMAIL PROTECTED]> wrote: > I knew that SQLite doesn't allow concurrency for both read and write at the > same time. > My application is written in C++ so Is there any way that we can check if > there is any connection to the database so the second connection needs to >

[sqlite] Read and write in SQLite

2007-11-09 Thread Joanne Pham
Hi all, I knew that SQLite doesn't allow concurrency for both read and write at the same time. My application is written in C++ so Is there any way that we can check if there is any connection to the database so the second connection needs to wait. For example my application write to the databas