Deletes all records in a table that fall within a specified range.
- Type: RecordRef Identifies the table in which the deletion will occur. Only those records selected by the filters set for RecordRef are deleted.
- Type: Boolean Specifies whether the code in the OnDelete trigger will be executed. If this parameter is true, the code will be executed. If this parameter is false (default), the code will not be executed. This parameter is optional.
This function works the same way as the DELETEALL Function (Record).
The following example opens table 18 (Customer) as a RecordRef variable that is named CustomerRecRef. The FIELD Function (RecordRef) creates a FieldRef variable that is named MyFieldRef for field 1 (No.). From the No. field, the SETRANGE Function (FieldRef) selects records in the range from 10000 to 20000. The number of records in the range is displayed in a message box. The DELETEALL function deletes all records in that range. The number of records is displayed again. This time, 0 is displayed because all the records in the range are deleted. This example requires that you create the following variable and text constant in the C/AL Globals window.
|Text constant name||DataType||ENU value|
The number of records in the range is %1.
CustomerRecRef.OPEN(18); MyFieldRef := CustomerRecRef.FIELD(1); MyFieldRef.SETRANGE('10000' , '20000'); MESSAGE(Text000 ,CustomerRecRef.COUNT); CustomerRecRef.DELETEALL; MESSAGE(Text000 ,CustomerRecRef.COUNT);