Re: Table mutating! - what the hell does that mean?

From: Bob Withers <Bob.Withers_at_mci.com>
Date: Wed, 31 Mar 1999 20:30:00 GMT
Message-ID: <MPG.116c40f22c5ae0989692@news.mcit.com>

In article <370203ea.0_at_145.227.194.253>, mgumbs_at_hotmail.com says...
> In a trigger text, you cannot read from, insert or update the same table or
> any other child tables related to that table which the trigger is defined on
> otherwise the trigger is said to be 'mutating'.
>

It should also be noted that this is only true for row level triggers. Statement level triggers may access the table they are defined on.

Regards,
Bob Received on Wed Mar 31 1999 - 14:30:00 CST