Re: Trigger Code

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Sun, 21 Mar 2004 11:56:59 -0800
Message-ID: <1079898995.74040@yasure>

Redd wrote:

> --
> 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.

What you appear to want is for someone to do your school work for you. Hopefully no one will.

If you want to see examples go to:
http://www.psoug.org/reference/library.html

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)

Received on Sun Mar 21 2004 - 13:56:59 CST