Re: [DOTNET] Transaction rollback

2002-04-24 Thread Greg Gates
to commit or rollback. > >Hope this helps, >Bob Beauchemin >[EMAIL PROTECTED] > > >-Original Message- >From: Greg Gates [mailto:[EMAIL PROTECTED]] >Sent: Wednesday, April 24, 2002 1:16 PM >To: [EMAIL PROTECTED] >Subject: [DOTNET] Transaction rollback > > >

Re: [DOTNET] Transaction rollback

2002-04-24 Thread Beauchemin, Bob
to see if you still have an active transaction (>0) or not (=0) before attempting to commit or rollback. Hope this helps, Bob Beauchemin [EMAIL PROTECTED] -Original Message- From: Greg Gates [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 24, 2002 1:16 PM To: [EMAIL PROTECTED] Subjec

[DOTNET] Transaction rollback

2002-04-24 Thread Greg Gates
Hi everyone: I have a method that executes a batch of stored procedures wrapped in an ADO.NET transaction. Naturally I rollback the transaction if an exception occurs. However, an exception can occur in the catch block if a transaction rollback has already occurred in the database. (in this cas