Trigger question - deletion of records
399651Aug 8 2007 — edited Aug 9 2007Hello All,
I have a question about triggers. I have a before delete trigger that will copy a record to a retire table before it is deleted from a business table. That all works fine, but I also want the trigger to raise an error if the record to be deleted does not exist in the business table. I have tried various things and cannot seem to get this part to work.
Is it possible for a before or after delete trigger to raise an error about a record that does not exist in a table? Does anyone have any examples?
many thanks!!