Re: [sqlite] [Query] Sqlite

What's your question on SQLite? (The sqlite-users@sqlite.org address is fairly straightforward. It's sort of like a forum style of help, where you ask your question via e-mail and 90-95% of the answers come from roughly 10 seemingly never-sleeping experts from around the English-speaking world.

Re: [sqlite] Query Sqlite lock state

Igor Tandetnik wrote: > "Marcus Grimm" <[EMAIL PROTECTED]> wrote > in message news:[EMAIL PROTECTED] >> is there a way to query if the database file is currently locked ? > > How would it help? Between the time you would obtain this information, > and the time you could act on it, the answer

Re: [sqlite] Query Sqlite lock state

John Stanton wrote: > How about performing your backup inside an exlclusive transaction? hm, good idea! ;) Probably that will lock the file (i.e. the database) and protect from a FileCopy, anyway: I'll try that. Thanks for the reply Marcus > > Marcus Grimm wrote: >> Hello all, >> >> is

Re: [sqlite] Query Sqlite lock state

"Marcus Grimm" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > is there a way to query if the database file is currently locked ? How would it help? Between the time you would obtain this information, and the time you could act on it, the answer may very well change. Just try

Re: [sqlite] Query Sqlite lock state

How about performing your backup inside an exlclusive transaction? Marcus Grimm wrote: > Hello all, > > is there a way to query if the database file is currently locked ? > > Background: > My application may run for weeks (hopefully) and uses EXCLUSIVE > transactions in some threads. On a daily

[sqlite] Query Sqlite lock state

Hello all, is there a way to query if the database file is currently locked ? Background: My application may run for weeks (hopefully) and uses EXCLUSIVE transactions in some threads. On a daily basis I would like to copy the database file for backup purpose. I assume that this will fail when