Difference between revisions of "RECNO()"

From Recital Documentation Wiki
Jump to: navigation, search
Line 1: Line 1:
=RECNO()=
 
 
 
 
==Class==
 
==Class==
 
Fields And Records
 
Fields And Records

Revision as of 13:54, 19 June 2009

Class

Fields And Records


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