Visual LANSA Forum

If my table has 1 to many records for an order#, If I issue this update:

#LOC := ' '
#ORDER := 12345
update fields(#LOC) in_file(ORDERS) with_key(#ORDER)

Does it update all of the records or just the first one?

Hi Art,

It will update all the records for that order number.

https://docs.lansa.com/15/en/lansa015/i ... DATE_C.htm

"Since the UPDATE command has a WITH_KEY or WITH_RRN parameter it is indicating that a specific record (or group of records) should be read and updated."

Thanks I didn't see the group of records comment.