The above logic was behind a field value change. However, the 'amt' kept on showing zero rather than the correct value. It transpired that an UPDATE statement was needed before the above code. It almost seems that the range table was not being picked up without the update. I cannot explain the reason for this misbehaviour but I do hope it saves someone a little bit of time. It is especially disconcerting as it was not a logic error but some idiosyncrasy of Proclaim.
Code: Select all
amt = RANGE("my range",my_amount