Hi,

Only if you raise an exception in the trigger.

I have that for some 'system' data.

Example:

BEGIN
if (old.GEBRUIKERSNAAM = 'SERP')
then exception DELETE_NOT_ALLOWED;
END

Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird
http://www.interbaseworkbench.com


Hi,

I just want to know if it's possible to cancel the deletion of a record via
the BEFORE DELETE trigger.

Thanks in advance.


[Non-text portions of this message have been removed]