Re: [sqlite] Detach says database is locked

2010-10-21 Thread Jim Wilcoxson
This type of thing works with SQLite 3.6.18. I have a similar issue with 3.7. I believe the difference is that in 3.6.18, if you do a select on a main database that doesn't involve an attached database, the attached database isn't locked. In 3.7, if you do a select on the main database that

Re: [sqlite] Detach says database is locked

2010-10-21 Thread Alan Chandler
On 21/10/10 00:35, Igor Tandetnik wrote: > Alan Chandler wrote: >> Further to my other post related to attaching to databases with PHP PDO, >> I have now managed to ATTACH OK >> >> However, when I come to DETACH, I am getting a Database is locked error >> when I try

Re: [sqlite] Detach says database is locked

2010-10-20 Thread Simon Slavin
On 21 Oct 2010, at 12:27am, Alan Chandler wrote: > The only thing happening to that database in between ATTACH and DETACH > is a single row SELECT If you try it without the SELECT does it work ? Does the SELECT return any results ? Simon. ___

Re: [sqlite] Detach says database is locked

2010-10-20 Thread Igor Tandetnik
Alan Chandler wrote: > Further to my other post related to attaching to databases with PHP PDO, > I have now managed to ATTACH OK > > However, when I come to DETACH, I am getting a Database is locked error > when I try and execute it. > > The only thing happening to