Re: trigger help

Mike Trozzo wrote:
>
> Knut,
>
> Thanks for responding. Orders_detail is a table joined on order_ID to
> orders_master and joined on material_ID to materials. Are you saying that I
> should be referencing that table with a select statement?

Yes, I think so. In your update statement the trigger does not know the values for orders_detail.qty_ordered, orders_detail.order_ID and orders_detail.material_ID because you are not selecting it anywhere. You'll have to integrate a select statement (either in the update statement or you do it in a seperate statement before the update) to get the needed values.

Regards,

Knut

-- 
Dipl.-Inform. Knut Talman                       Fon +49.30.72 62 01 411
myToys.de GmbH                                  Fax +49.30.72 62 01 222
Schoenhauser Allee 36-39                        Mobil +49.173.671 65 65
D-10435 Berlin