Reading the paper http://www.tcl.tk/community/tcl2004/Papers/D.RichardHipp/drh.html I'm trying to use the ability to work using "in-memory-database". But there is a problem: sometimes the data doesn't get transferred from memory back onto disk. The procedure, that I wrote, is fairly simple:
#v+ # ...dblock & dbcomm are both active... dblock eval {SELECT name FROM sqlite_master WHERE type='table'} { dblock eval "DELETE FROM $name" } dblock close dbcomm eval {ATTACH $fullPath2dbase AS app} dbcomm eval {SELECT name FROM sqlite_master WHERE type='table'} { dbcomm eval "INSERT INTO app.$name SELECT * FROM $name" } dbcomm eval {DETACH app} dbcomm close #v- The problem is, that the above _in most cases_ works, but _just sometimes_ it isn't working - and because of this it's difficult to trace. Any ideas, what can be the reason? -- pozdrawiam / regards Zbigniew Baniewski _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users