NEXT Function (Record)

Article
06/05/2016

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

Syntax


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.

Partager via