RE: [sqlite] tcl/sqlite executing code on failed transaction

2004-02-07 Thread jim
-Original Message- From: Kurt Welgehausen [mailto:[EMAIL PROTECTED] Sent: Saturday, February 07, 2004 5:40 PM To: [EMAIL PROTECTED] Subject: Re: [sqlite] tcl/sqlite executing code on failed transaction You should take a look at tcl's catch command. You could put all your SQLite

Re: [sqlite] tcl/sqlite executing code on failed transaction

2004-02-07 Thread Kurt Welgehausen
You should take a look at tcl's catch command. You could put all your SQLite code in one catch command, if {[catch { db eval begin ;# or maybe {begin on conflict rollback} db eval {... } db eval {... } db eval {... } db eval commit} err]} { doSomething $err } or you

[sqlite] tcl/sqlite executing code on failed transaction

2004-02-07 Thread jim
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 eva