Mutating Error
From: JimS <james.stewart2_at_ccra-adrc.gc.ca>
Date: 22 Nov 2002 11:25:31 -0800
Message-ID: <e8ba4080.0211221125.32d7c1b6_at_posting.google.com>
Hi,
Date: 22 Nov 2002 11:25:31 -0800
Message-ID: <e8ba4080.0211221125.32d7c1b6_at_posting.google.com>
Hi,
[Quoted] I have a problem that I think someone can help me with. I create a BEFORE trigger on one of my tables. In the trigger I perform a SELECT to verify if a value exists before performing the update. It give me a "mutating error". Can I not code SELECT's in Triggers. It seems to simple. If so, why am I getting this error.
Thanks in advance.
Jim
P.S. If you would like to email, send to james.stewart2_at_nospamccra-adrc.gc.ca
Please omit nospam to email. Received on Fri Nov 22 2002 - 20:25:31 CET