Subject | Cancelling an operation in a Trigger |
---|---|
Author | Anand |
Post date | 2003-08-14T11:23:27Z |
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
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