Dan,
Could you please take this to the ib-support list? The list you are
posting to here is for general discussion, not support questions.

Subscribe directly:

<mailto:ib-support-subscribe@yahoogroups.com>

thks
Helen
(resident witch)

At 12:44 PM 3/06/2003 +0000, Dan Statham wrote:

>Good Morning!
>
> I have Firebird 1.0.0.796.
>
> 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!)
>
>Thanks...Dan'l
>
>
>Community email addresses:
> Post message: Firebird-general@yahoogroups.com
> Subscribe: Firebird-general-subscribe@yahoogroups.com
> Unsubscribe: Firebird-general-unsubscribe@yahoogroups.com
> List owner: Firebird-general-owner@yahoogroups.com
>
>Shortcut URL to this page:
> http://www.yahoogroups.com/community/Firebird-general
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/