April 2017
Intermediate to advanced
706 pages
17h 8m
English
DELETEALL is the high-volume version of the DELETE function. If we have a group of records that we wish to delete, use DELETEALL. The other choice would be a FIND-NEXT loop, in which we delete each record one at a time. The advantage of the DELETEALL function is that it allows the developer and the system to optimize code for the volume deletion. Any system optimization will be a function of what SQL statements are generated by the C/AL compiler.
The syntax for DELETEALL is as follows:
Record.DELETEALL ( [,TriggerControlBoolean] )
The TriggerControlBoolean value, a TRUE or FALSE entry, controls whether or not the table's OnDelete trigger fires when this DELETE occurs. The default value is FALSE. If the TriggerControlBoolean ...
Read now
Unlock full access