Deletes all records in a table that fall within a specified range.

RecordRef.DELETEALL([RunTrigger])

Parameters

RecordRef

Type: RecordRef

Identifies the table in which the deletion will occur. Only those records selected by the filters set for RecordRef are deleted.

RunTrigger

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.

Remarks

This function works the same way as the DELETEALL Function (Record).

Example

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.

Copy Code
CustomerRecRef.OPEN(18);
MyFieldRef := CustomerRecRef.FIELD(1);
MyFieldRef.SETRANGE('10000' , '20000');
MESSAGE(Text000 ,CustomerRecRef.COUNT);
CustomerRecRef.DELETEALL;
MESSAGE(Text000 ,CustomerRecRef.COUNT);

See Also