Subject | Re: [firebird-support] New context in After trigger |
---|---|
Author | Thomas Steinmaurer |
Post date | 2008-05-20T11:51:10Z |
> In FB 2.1 my "used to work triggers" in 1.5 update a field in theNEW.<column> is read-only in AFTER triggers.
> 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.
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