Updating fields directly using Progress

[alan180274]

We using the ERP system MFG/Pro which uses a progress database.
I am relative progress novice, but i know how to retrieve and outpur data
via the For each and output commands.

however, how do i update a field directly in a progress table without having to
use the erp screen.

do i use update or set ? I tried using as an example
to set the currency to GBP for a particualr customer.

for each ar_mstr where ar_num = "02001975":
set ar_curr = "GBP".
end.

however this did not work - could anyone please advise ?

regards

Alan

 

[Ben Marchese]

Try the assign statement:

for each ar_mstr where ar_num = "02001975":
assign ar_curr = "GBP".
end.

Note: Be carefull directly updating fields in this application. You can really mess things up if you're not familiar with the data flows between tables.

Good Luck!

 

[Kishor Chari]

DONT DO IT. Try to fix it thru interface.
There are many more tables that get updated.