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
 
 

Reply via email to