Subject Re: [firebird-support] New context in After trigger
Author Thomas Steinmaurer
> In FB 2.1 my "used to work triggers" in 1.5 update a field in the
> table that owns the trigger. For example a field that calculates amounts
> excl. VAT, VAT etc.
>
>
>
> In 2.1 these new.fields are read only. What's the best way to calculate
> these fields now.

NEW.<column> is read-only in AFTER triggers.

Try to use a BEFORE trigger instead.



--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com