Hi i have a related field that i want to update. i have tried using the trigger to update a certain field but it doesn't work or either i just got confuse upon the query type.anyways, if anyone has the idea on updating one field table to another using the query would be a really great help. Thanks.
Hi,
Please check my reply in the below thread.
community.progress.com/.../75850
Hope it helps.
Thanks and Regards,
Chandu.
hi
im trying this code in my trigger
var app = new QTY (rbv.api.SetFieldValue("Inventory_2.Quantity+Delivery_2.Quantity"));
UPDATE [Inventory].Quantity();
SET [Inventory].Quantity = Inventory.Quantity + Delivery.Quantity;
WHERE [Inventory].Item_code = Delivery.Item_Code;
but i ended up having the same error again and again which is
Error "QTY" is not defined. (line #1) in formula:
Error "UPDATE" is not defined. (line #1) in formula: