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
