Hi, I have a question about the triggers in Sybase.
I would like to execute the following trigger but only if the original delete operation was successful. Is this something that I have to code in the trigger, or is it not necessary? If it is needed, please help me with the code!
Thank you!
SJH
I would like to execute the following trigger but only if the original delete operation was successful. Is this something that I have to code in the trigger, or is it not necessary? If it is needed, please help me with the code!
Thank you!
SJH
Code:
CREATE TRIGGER AfterDelete_myTable
AFTER DELETE ORDER 1 ON myTable
REFERENCING OLD AS deleted
FOR EACH ROW
BEGIN
DELETE FROM myTable
WHERE myTable.parent_id = deleted.id;
END