You are here: Functions > RECNO()

RECNO()

RECNO() returns the current logical record number, counting from 1.

Use RECNO() to output record numbers to a file or when examining a file for the first time to determine the relative location of a particular record within a file.

Function Format

RECNO()

RECNO() returns the current logical record number. If the file is not indexed, RECNO() starts with a value of 1 and increases by one for each record in the file. The logical and physical record numbers are identical.

If the file is indexed, RECNO() behaves similarly, but in a logical, not physical order. If the SEEK or FIND commands are used, the record number is reset to 1 after you execute these commands.

Examples

For record 99:

RECNO() = 99