>Hello
>
>I have a hierarchical table, containing ID and ParentID fields. I have created a self-join on these two fields, then I have created a RI rule (using RI builder), that deletes the subordinate records when a parent record is deleted.
>
>I was surprised to find that this doesn't work. Instead I get a "Trigger failed" message. Now follows the question: Is there any way (beside recursive scanning) to delete all the subordinated records (and theirs subordinate records, and so on) when I delete a parent record?
>
>Thanks.
You can not update the same table in a trigger. You may execute some code from the place when you delete a record (not in a trigger) or you may try to use Table Rule, but then you would have to use InActive flag first...
If it's not broken, fix it until it is.
My Blog