Re: [sqlite] multiple conections for the same database

2010-08-18 Thread Pavel Ivanov
avel 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 will allow y

Re: [sqlite] multiple conections for the same database

2010-08-18 Thread Black, Michael (IS)
vanov 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 >

Re: [sqlite] multiple conections for the same database

2010-08-18 Thread 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 the same time. You can'

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 database >

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 > http:

Re: [sqlite] multiple conections for the same database

2010-08-18 Thread Igor Tandetnik
andres felipe tamayo cortes wrote: > 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 >

[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 a