June 8, 2002 at 8:38 am
Hi all,
I am trying to write a trigger that updates a column of the record being updated in the same table, I know the trigger will fire again on that update but my question is, is there a way of detecting this updated column and do nothing so it will not fire again?
TIA
JW
June 8, 2002 at 9:07 am
That will happen automatically unless you enable recursive triggers, which is disabled by default and not likely to be needed!
Andy
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy