Delete cascade trigger

[tamas]

Hi,
I have a self-referencing table, something like Emlplyee-Manager. I want to implement the cascading delete in this table. So when I delete a manager than all the employees should be deleted at ANY level below the manager.
My problem is that the trigger fires only one time (for the "sons&quot and not for the "grandsons" and below, although the nested trigger setting checkbox is set.
Any idea why the trigger doesn't fire for "grandsons" and below?

 

[rajeevnandanmishra]

Hi tamas,
In SQL, A trigger will not execute again if you update the respective table with in the trigger.
I suggest you to create a procedure for deletion of sons and grandsons and ...
And call that procedure within the trigger.