Re: help with triggers
Date: 1998/03/11
Message-ID: <6e7djq$2ivu$1_at_newssvr03-int.news.prodigy.com>#1/1
Hi Laurent,
Yes you can, but you cannot do it in a row level trigger. You must do it in a statement level trigger. Otherwise you will get the dreaded "Mutating trigger" error....
What I have done is; in row level trigger on the main table I would write the pertinent data to a temp table.
Then in the statement level trigger (which fires after all row levels have completed) I read from the temp table and insert/update/delete as necessary from the main table ( the one caused the row level trigger to fire).
Hope this is clear enough to help.
Alex
Laurent wrote in message <3505707A.41C6_at_ex.ac.uk>...
>Hi,
>
>I have a problem with on triggers:
>
>is it possible to update one row in a trigger if a change of the same
>was the triggering event??????
Received on Wed Mar 11 1998 - 00:00:00 CET