Share via


NEXT Function (Record)

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

Steps := Record.NEXT([Steps])

Parameters

  • Record
    Type: Record The record from which the search starts.
  • Steps
    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.

Remarks

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.

Example

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
  REPEAT
    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

Reference

Record Data Type

Concepts

GET, FIND, and NEXT Functions