MODIFYALL function
MODIFYALL is the high-volume version of the MODIFY function. If we have a group of records for which we wish to modify one field in all of them to the same new value, we should use MODIFYALL. MODIFYALL is controlled by the filters that apply at the time of invoking. The other choice for doing a mass modification would be to have a FIND–NEXT loop in which we modify each record, one at a time. The advantage of MODIFYALL is that it allows the developer and the system to optimize the code for the volume update. Any system optimization will be a function of the SQL statements are generated by the C/AL compiler.
The syntax for MODIFYALL is as follows:
Record.MODIFYALL (FieldToBeModified,NewValue [,TriggerControlBoolean ] )
The TriggerControlBoolean
value, a TRUE or FALSE entry, controls whether or not the table's OnModify trigger fires when this MODIFY occurs. The default value is FALSE which would result in the field OnValidate trigger not being executed...
