On Jan 20, 2008 9:16 PM, Ken <[EMAIL PROTECTED]> wrote: > Jay > > I've used a trigger to do this with good success. > > You'll need one trigger per table to cause the delete to cascade through > the tree. > > Or if you know that you will always delete from the top level tree"parent" > then just one trigger would probably suffice.
I wonder why yours works but Ken's doesn't. In mine one trigger should do it, but it would have to be recursive. ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
