Re: [sqlite] Checking for open transactions attach/detach database

2008-05-27 Thread MoDementia
: General Discussion of SQLite Database Subject: Re: [sqlite] Checking for open transactions attach/detach database MoDementia wrote: > The database file is ready to (copy) Detach as soon as the commit completes. > Yes. > This is the problem. > Detach: "This statement will fai

Re: [sqlite] Checking for open transactions attach/detach database

2008-05-27 Thread MoDementia
ite Database Subject: Re: [sqlite] Checking for open transactions attach/detach database MoDementia wrote: > The database file is ready to (copy) Detach as soon as the commit completes. > Yes. > This is the problem. > Detach: "This statement will fail if SQLite is in the midd

Re: [sqlite] Checking for open transactions attach/detach database and Trigger behaviour with attached databases

2008-05-25 Thread MoDementia
What is the appropriate etiquette if I don't receive a solution/answer in ?? days -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of MoDementia Sent: Friday, 23 May 2008 12:32 PM To: sqlite-users@sqlite.org Subject: [sqlite] Checking for open transactions

[sqlite] Checking for open transactions attach/detach database and Trigger behaviour with attached databases

2008-05-22 Thread MoDementia
Hi, My first submission 1 Problem and 1 question J My problem I have 2 processes that are causing problems after commits/locks 1. Copy main database to copydatabase using filesystem object How to determine when copydatabase is ready for attach? Attach copydatabase <-- need to