Subject Re: [firebird-support] Big problem trigger
Author Anderson Farias
Hi,


> The same trigger I have created as update-trigger to change the price if
> the
> part-no. (teilenr) or amaount is changed.
>
> Now, I need to set the field "preisber" with the value 1 (if price model
> one
> set the price), 2 (if price model two) or 3 if price model three)
>
> But it does not work. No matter if I set another value in the trigger, the
> value doensn't change.


Re-check trigger code (you did not post it complete) and... look for any
other *before update* triggers on this table with position equal to or
greater than this "problem" trigger


Regards,
Anderson Farias