How to update table from oracle form
Hi,
I have a three tables received(master) received_detail (detail) and product_master table.
I build a form using master detail table and want to update one column(current_ stock) in product_master table from oracle forms when save the master detail records. For this purpose I used following update routine in on_update trigger in form level but it does not work.
Every thing is working fine except qty does not update in qty column of product_master table.
UPDATE PRODUCTS_MASTER
SET CURRENT_STOCK = CURRENT_STOCK + :RECEIVED_DETAIL.QTY
WHERE PRODUCTS.CODE = :RCTRAN.PRODCODE
commit;
Kindly give me the solution.
Hassan