Hi all,
 i have three tables Customer, Product, Order in my database. what i am trying to do is when i enter the customer order quantity in order table, it should fire trigger and update the quantity_on_hand field in product table(e.g. if customer wanst to order product_id 1 in the amount of 5, if i have quantity_on_hand in product table is 15, after inserting customer order, the quantity_on_ hand should be 15-5=10). i tried to write following trigger, but when i execute the following code in Query analyzer, it gives me error message

CREATE TRIGGER tgInsertOrder
ON Order
FOR INSERT
AS
BEGIN
    declare @product_id int
    declare @order_qty int

    @product_id = product_id,
    @order_qty = order_qty
from inserted
update product
set quantity_on_hand = quantity_on_hand - @order_qty
where product_id = @product_id

END
GO
i get following error
Server: Msg 170, Level 15, State 1, Procedure tgInsOrder, Line 9
Line 9: Incorrect syntax near '@product_id'.
Server: Msg 137, Level 15, State 1, Procedure tgInsOrder, Line 13
Must declare the variable '@order_qty'.

any help or sample code would be greatly appreciated

I have work on something similar

createTRIGGER dbo."UpdateQuantity" ON dbo.Order_Details
FOR INSERT
Not for replication
AS
UPDATE dbo.products
SET dbo.products.UnitsSold=inserted.Quantity + inserted.Quantity
FROM inserted
where dbo.products.productID=inserted.productID

Search on previous post because someone already help me with this.

everest, i think the begin and end are not required in your trigger.

hi,
 evenif i deleted begin and end, it still doesn't seem to work

further help would be great

i came accross this problem. thanks for the help
i solved the problem

what was your solution, can you post it?