Subject Cancelling an operation in a Trigger
Author Anand
Is there any way in FireBird to cancel an INSERT or UPDATE or
DELETE operation from a BEFORE... trigger? For e.g. if the user
tries to delete a row from a table and I need to do some
validations before the row can be deleted, is there any way I
could write a BEFORE DELETE trigger that would perform the
validations and cancel the delete operation if a certain result
was not found?

Thanks in advance for any tips and suggestions,

Anand

__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com