Re: Trigger Code
From: Redd <javatek?_at_usa.com>
Date: Sat, 20 Mar 2004 19:39:25 -0600
Message-ID: <Sj67c.58974$xL3.40979_at_bignews1.bellsouth.net>
Date: Sat, 20 Mar 2004 19:39:25 -0600
Message-ID: <Sj67c.58974$xL3.40979_at_bignews1.bellsouth.net>
> I am trying to implement a trigger to update a field and
> these are the columns.
>
>
> Quantity Integer
> OldQuantity Integer
> OnOrder Char
>
>
> Does anyone know how to write the trigger that on update
> if Quantity is equal to or less than OldQuantity write the
> Character "T" to the OnOrder field.
>
>
>
>
Received on Sun Mar 21 2004 - 02:39:25 CET