Hello Eric,

> 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. Are SP's the best solution for this, these are
> relative simple calculations and for me maintaining the code is easier
> in triggers...

You can still use the NEW.<something> values to calculate, but
the actual update cannot be done via NEW in an After trigger. As
far as I know, this has always been the case.

Can you show us some code that fails now?

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com