--
javatek?@usa.com
remove the ? to reply.
"Mark C. Stock" <mcstockX_at_Xenquery .com> wrote in message
news:PfWdnc-muMypasHdRVn-gQ_at_comcast.com...
> | 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.
> |
> |
> |
> |
>
> use a 'before update ... for each row' trigger with a 'when' condition
that
> compares the oldquantity and new quantity, and assign the value 'T' to
> onorder
What I would like is to see what that actual code segment would look like.
We are going to use this as a small test to see if any of the DBAs to be
interviewed can write triggers. I am not a programmer.
Received on Sat Mar 20 2004 - 20:07:34 CST
