Difference between revisions of "RECNO()"

Revision as of 15:59, 28 October 2009

Purpose

Function to return current record number

Syntax

RECNO([<workarea | alias> [<expN>])

See Also

ALIAS(), BOF(), DBF(), EOF(), FOUND(), GOTO, RECCOUNT(), SEEK, SEEK(), SELECT, SELECT(), SEQNO(), SKIP, UNIQUEROWID(), USE

Description

The RECNO() function returns the record number of the current record in the currently selected table file. Note that when using indexed tables, RECNO() returns a physical record number in the table, and not a record number relative to the index. If the optional <workarea | alias> is specified, then the function will operate in the required location. The optional <expN> can be used as a softseek function when the value of 0 is specified. If a seek fails on an index table, RECNO(0) will return the record number for the record above the SEEK expression value with respect to the index.

Example

use accounts index acc_no
? recno()
         1
goto 35
? recno()
        35

Products

Recital Database Server, Recital Mirage Server, Recital Terminal Developer