Re: [sqlite] multiple conections for the same database

2010-08-18 Thread Pavel Ivanov
on behalf of Pavel Ivanov > Sent: Wed 8/18/2010 9:57 AM > To: General Discussion of SQLite Database > Subject: EXTERNAL:Re: [sqlite] multiple conections for the same database > > > >> Which means the read works on old data until you COMMIT? >> Is that true?  So that COMMIT wi

Re: [sqlite] multiple conections for the same database

2010-08-18 Thread Black, Michael (IS)
Sent: Wed 8/18/2010 9:57 AM To: General Discussion of SQLite Database Subject: EXTERNAL:Re: [sqlite] multiple conections for the same database > Which means the read works on old data until you COMMIT? > Is that true? So that COMMIT will allow you to query the changed/new data > from

Re: [sqlite] multiple conections for the same database

2010-08-18 Thread Pavel Ivanov
n behalf of Pavel Ivanov > Sent: Wed 8/18/2010 9:15 AM > To: General Discussion of SQLite Database > Subject: EXTERNAL:Re: [sqlite] multiple conections for the same database > > > >> SQLite allows multiple readers, or exactly one wrier, accessing the database >> at t

Re: [sqlite] multiple conections for the same database

2010-08-18 Thread Black, Michael (IS)
From: sqlite-users-boun...@sqlite.org on behalf of Pavel Ivanov Sent: Wed 8/18/2010 9:15 AM To: General Discussion of SQLite Database Subject: EXTERNAL:Re: [sqlite] multiple conections for the same database > SQLite allows multiple readers, or exactly one wrier, accessing the datab

Re: [sqlite] multiple conections for the same database

2010-08-18 Thread Pavel Ivanov
> SQLite allows multiple readers, or exactly one wrier, accessing the database > at the same time. You can't read and write simultaneously, you must arrange > for your connections to take turns. SQLITE_BUSY error is a signal for you to > back off, wait a little, then try again. See also >

[sqlite] multiple conections for the same database

2010-08-18 Thread andres felipe tamayo cortes
HI, i have a doubt: i have one application who reads a database, it run well without problems, but when i tried to load this dabase from other program (while its still running the first application), appearsme database blocked, isnt it possible to load one database from more than one programm