-----Message d'origine-----
De : jm cuaz [mailto:jm.c...@orens.fr]
Envoyé : vendredi 9 octobre 2009 16:13
À : sqlite-users@sqlite.org
Objet : Tcl API - DROP TABLE when processing the results of a querry one row at
a time
Hello,
SQlite 3.6.10 - no "shared-cahe mode" - no explicit transaction
When using "db1 eval {SELECT ... FROM T1..} array-name {script}"
construction in Tcl, {script} can't execute "db1 eval {DROP TABLE T2}
statements which fail with "database table is locked" error message.
However, other sql statements are successfully executed in {script}
(using the same handle "db1 eval...") *including "db1 eval {CREATE
TABLE}"*.
Should we use the "shared-cache" mode of SQLite to allow the execution
of "DROP TABLE" sql statement inside this sort of construction ? (some
words about this may be usefull in the Tcl API Documentation).
Thanks
Jean-Marie
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
