MODIFY function
The purpose of the MODIFY
function is to modify (update) the existing data records. The syntax for MODIFY
is:
[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 or not 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.
There is system based checking to make sure that a MODIFY
is done using the current version of the data record by making sure that another process hasn't modified and committed the record after it was read by this process...