Re: Delete trigger

From: Mark D Powell <mark.powellNOmaSPAM_at_eds.com.invalid>
Date: 2000/07/12
Message-ID: <0236ff0d.199f06d4@usw-ex0102-015.remarq.com>#1/1

"Yann Cauchard" <yann.cauchard_at_spcconsultants.com> wrote:
>Hello,
>
>I have to avoid deleting lines in a table using a trigger.
>I started to write a before delete trigger, which returns some
error
>messages.
>But i'd like to return no messages, or a custom message.
>Can someone help ?
>
>Thanks in advance.
>
>Yann CAUCHARD
>

The only way I can think of to stop the delete would be to raise_application_error(-20002,'Deletes are not allowed'). This will allow you to send a message, but I do not know any way to send no message, but depending on the front-end applicaion you should be able to control what the user sees.

Got questions? Get answers over the phone at Keen.com. Up to 100 minutes free!
http://www.keen.com Received on Wed Jul 12 2000 - 00:00:00 CDT