You may not DETACH while a query is running. This is to prevent the
DETACH from closing a database connection out from under the running
query.
On 11/9/16, Jean-Baptiste Gardette <jb.garde...@orens.fr> wrote:
> On Window 7 with tcl/tk 8.6.6 and SQLite 3.13.0
>
> The following tcl script craches :
>
> package require sqlite3
>
> sqlite3 db1 dbfile1
>
> db1 eval "SELECT A FROM TableA" {
>
> db1 eval "ATTACH DATABASE dbfile2 AS 'dbfile2'"
>
> db1 eval "SELECT B FROM dbfile2.TableB"
>
> db1 eval "DETACH DATABASE dbfile2"
> }
>
> Error message :
> database dbfile2 is locked
> while executing
> "db1 eval "DETACH DATABASE dbfile2""
>
> Please, if anyone could explain to me what's wrong.
>
> Thanks
> Jean-Baptiste
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
--
D. Richard Hipp
d...@sqlite.org
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
