Hi- I noticed when a transaction fails my files arent getting closed. maybe the db is getting closed...not sure. Is there a way so after the error message pops up on the screen telling me the reason the transaction failed I can clean up ? thanks, marvin db eval { begin transaction; } db eval " $getval " if {$mode > 0 } { db eval " INSERT INTO t1 ($str) select * from $tbl " } else { db eval " INSERT INTO t1 select * from $tbl " } db eval " drop table $tbl; " db eval " $getval1 " db eval " INSERT INTO $tbl select * from t1 " db eval { drop table t1 } while { ![eof $resultfile3] } { # tk_messageBox -message [gets $resultfile3] db eval "[gets $resultfile3]" } db eval { commit; }
db close close $resultfile1 close $resultfile2 close $resultfile3