Up Prev Next
From: Michael Peppler <mpeppler at peppler dot org>
Subject: Re: Transactions
Date: Aug 25 1999 11:13PM
Roger Hall writes:
> I was wondering if anyone could explain the following, or point me at
> an example or document that explains what I'm doing wrong. The following
> code runs fine. I run it as a normal user and so the select gives me
> a couple of permission denied errors and then my error saying 'OUCH'.
> If I un-comment the two transaction lines, I still get the two permission
> errors, but my 'OUCH' error no longer gets output.
What I think happens is that when you have a begin tran the
transaction is automatically rolled back when you hit an error, so the
raiserror is never called (in this case).
Although I may be completely wrong, of course!
Michael Peppler -||- Data Migrations Inc.
email@example.com -||- http://www.mbay.net/~mpeppler
Int. Sybase User Group -||- http://www.isug.com
Sybase on Linux mailing list: firstname.lastname@example.org