NEXT Function (Record)

Steps through a specified number of records and retrieves a record.


Steps := Record.NEXT([Steps])  


Type: Record

The record from which the search starts.

Type: Integer

Specifies the direction of the search and how many records to step over. This parameter follows the following rules:

  • >0 Search Steps records forward in the table.

  • <0 Search Steps records backward in the table.

  • =0 Stay on the same record in the table.

    If you do not specify this parameter, then the next record is found.

Property Value/Return Value

Type: Integer

The number of records inspected which meet the criteria of any filters and the current key. This value can be less than Steps, depending on the number of records in the table. If the table is empty, then zero is returned and Record does not change.


This function locates a record positioned a given number of steps forward or backward from Record. Movement through the table is governed by the filters and the current key associated with the records. The fields in Record that will be compared with the current key fields must contain appropriate values before the function is called.


This example requires that you create the following variables in the C/AL Globals window.

Variable name DataType Subtype
Count Integer Not applicable
CustomerRec Record Customer
Count := 0;  
IF CustomerRec.FIND('-') THEN  
    Count := Count + 1;  
  UNTIL CustomerRec.NEXT = 0;  

This code uses a REPEAT UNTIL loop to count the number of entries in the Customer table. The FIND function finds the first entry in the table. Each time the NEXT function is called, it steps one record forward. When NEXT equals zero (0), there are no more entries in the table and the loop is exited.

See Also

Record Data Type
GET, FIND, and NEXT Functions