UPDATING FIELD VALUE II

Posted by chris13 on 25-Nov-2015 22:13

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.

All Replies

Posted by Chandrasekhar Gontla on 25-Nov-2015 23:45

Hi,

Please check my reply in the below thread.

community.progress.com/.../75850

Hope it helps.

Thanks and Regards,

Chandu.

Posted by chris13 on 26-Nov-2015 21:56

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:

This thread is closed