Re: trigger help

Comments embeded.

Mike Trozzo wrote:
<snip>
> SQL> create or replace trigger receive
> 2 after insert or update on orders_master
> 3 for each row
> 4 when (old.received_date IS NULL
> 5 and new.received_date IS NOT NULL)
> 6 begin
> 7 update materials set qty_onhand =
> 8 (qty_onhand + orders_detail.qty_ordered)

Where do you get orders_detail.qty_ordered from?

> 9 where :new.order_ID = orders_detail.order_ID

Same question: Where do you get orders_detail.order_ID from?

> 10 and materials.material_ID = orders_detail.material_ID;

Where do you select orders_detail.material_ID;?

> 11 end receive;
> 12 /

Regards,

Knut Received on Wed May 08 2002 - 10:54:29 CDT