Subject Re: [firebird-support] problem with before update trigger
Author Fernando Medeiros
might be necessary to display the code of the trigger, so we can help you
with this problem.

Fernando Medeiros
http://fernandomedeiros.com.br/blog

2009/12/9 Maurizio P. <mauriz_po@...>

>
>
> 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]
>
>
>



--
http://twitter.com/fernandomds
http://fernandomedeiros.com.br/blog


[Non-text portions of this message have been removed]