SET TERM!!; CREATE TRIGGER my_Delete_Confirmation_Trigger FOR mytable ACTIVE BEFORE DELETE AS BEGIN IF (KEY < 999) THEN (abort the deletion) END!!How do I implement the "(abort the deletion)" part?
CREATE EXCEPTION CANT_DELETE_RECORD 'This record cannot be deleted.'The use the exception in your trigger like this:
SET TERM!!; CREATE TRIGGER my_Delete_Confirmation_Trigger FOR mytable ACTIVE BEFORE DELETE AS BEGIN IF (KEY < 999) THEN EXCEPTION CANT_DELETE_THIS_RECORD END!!
Last Modified: 15-OCT-02