Subject | problem with before update trigger |
---|---|
Author | Maurizio P. |
Post date | 2009-12-09T22:27:54Z |
hi ,
maybe it is late , so i can't be over
a little silly problem :
in a table i have a field 'testupdated' ,
in the same table in the before update event i have
a trigger : ' mytable.testupdated = 'S' ,
of course i can''t set its value to 'N' ......that trigger will change it in 'S' ,
is it possible to exclude fields from that event ?
.... in other words : don't fire the trigger when the field 'testupdated' changes .
thanks
Mauro
[Non-text portions of this message have been removed]
maybe it is late , so i can't be over
a little silly problem :
in a table i have a field 'testupdated' ,
in the same table in the before update event i have
a trigger : ' mytable.testupdated = 'S' ,
of course i can''t set its value to 'N' ......that trigger will change it in 'S' ,
is it possible to exclude fields from that event ?
.... in other words : don't fire the trigger when the field 'testupdated' changes .
thanks
Mauro
[Non-text portions of this message have been removed]