Subject Setting a table's field value within the table's insert trigger
Author Dan Statham
Good Morning!

I have Firebird

I am trying to set some fields in a table based on variable
results from within the tables insert trigger.

I am looking up and or calculating some variables. Then, I am
using "New.TotQtyBefore=:Total_Before" (and other fields the same
way) but the field is comming up null. I have a "if (new.TotQtyBefore
is null) then new.TotQtyBefore =0" but it did not help.

How do I set a fields value from within an insert trigger?

Ther is no unique index field on the table. (Bummer!)