On 12 Feb 2004 at 15:26, James wrote:

>I always have value for the itemid, qty, and conversion field. I don't
>know where to look that cause my problem.

FB1.5RC8 may be the source of your problem. Try RC9. If this won't
help, log all involved fields to a table and see whether they have
expected values. Try to make a simple reproducible test case...

-------------------------- Cut here -------------------------------
2004-01-11 10:29 dimitr

* firebird2/src/jrd/cmp.cpp:

Fixed bug with computed fields referenced in a trigger context.
------------------------ And cut here -----------------------------

SY, Dimitry Sibiryakov.