The purpose of the MODIFY function is to modify (update) existing data records. The syntax for MODIFY is as follows:
[BooleanValue :=] Record.MODIFY ( [ TriggerControlBoolean ] )
If BooleanValue is not used and MODIFY fails, for example, if another process changes the record after it was read by this process, then the process will terminate with an error statement. The code should either handle a detected error or gracefully terminate the process. The TriggerControlBoolean value controls whether the table's OnModify trigger fires when this MODIFY occurs. The default value is FALSE, which would not perform any OnModify processing. MODIFY cannot be used to cause a change in a primary key field. In that case, the RENAME function must be used.
System-based checking can be performed to make sure that a MODIFY is done using the current version of the data record. This is done by making sure that another process hasn't modified and committed the record after it was...
