DELETEALL Function (RecordRef)

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.

Variable name DataType
CustomerRecRef RecordRef
MyFieldRef FieldRef
Text constant name DataType ENU value
Text000 Text The number of records in the range is %1.

MyFieldRef := CustomerRecRef.FIELD(1);  
MyFieldRef.SETRANGE('10000' , '20000');  
MESSAGE(Text000 ,CustomerRecRef.COUNT);  
MESSAGE(Text000 ,CustomerRecRef.COUNT);  

See Also

RecordRef Data Type
OnDelete Trigger