Re: Abort a Trigger

Article View: borland.public.interbase.sql

Article #822

Back to borland.public.interbase.sql Previous Next

#822

From: Adalberto Baldini
Date: Sun, 13 May 2007 07:34

16 lines
1451 bytes

Bill Todd wrote:
> Adalberto Baldini wrote:
> 
> 
>>how can I exit the trigger stopping it execution ?
> 
> 
> Raise an exception.
> 

if I don't manage error in executed procedure,
a) trigger gets an automatic exception and also raises an exception ?
b) or I need to raise my exception in trigger to force a rollback?

Thanks
Adalberto

Technical Details

Message-ID: <4646bf7a$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!feeder3.cambrium.nl!feeder5.cambrium.nl!feeder1.cambrium.nl!feed.tweaknews.nl!news2.euro.net!newsfeed.freenet.de!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

References: <4646324d@newsgroups.borland.com> <46465356$1@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,a5001e52ced62223
X-Google-Attributes: gid114a0e,public
X-Google-Language: ENGLISH,ASCII-7-bit
Date: Sun, 13 May 2007 09:34:20 +0200
From: Adalberto Baldini <finman@swissonline.ch>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.2) Gecko/20040804 Netscape/7.2 (ax)
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: borland.public.interbase.sql
Subject: Re: Abort a Trigger
References: <4646324d@newsgroups.borland.com> <46465356$1@newsgroups.borland.com>
In-Reply-To: <46465356$1@newsgroups.borland.com>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 84.74.35.221
Message-ID: <4646bf7a$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1179041658 84.74.35.221 (13 May 2007 00:34:18 -0700)
Lines: 16
Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!feeder3.cambrium.nl!feeder5.cambrium.nl!feeder1.cambrium.nl!feed.tweaknews.nl!news2.euro.net!newsfeed.freenet.de!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message