Retro video games delivered to your door every month!
Click above to get retro games delivered to your door ever month!
X-Hacker.org- CA-Clipper 5.3 . Guide To CA-Clipper - <b>recno()</b> http://www.X-Hacker.org [<<Previous Entry] [^^Up^^] [Next Entry>>] [Menu] [About The Guide]
 RECNO()
 Return the identity at the position of the record pointer
------------------------------------------------------------------------------
 Syntax

     RECNO() --> Identity

 Returns

     RECNO() returns the identity found at the position of the record
     pointer.

 Description

     RECNO() is a database function that returns the identity found at the
     current position of the record pointer.  Identity is a unique value
     guaranteed by the structure of the data file to reference a specific
     record of a data file.  The data file need not be a traditional Xbase
     file.  Therefore, unlike earlier versions of CA-Clipper, the value
     returned need not be a numeric data type.

     Under all RDDs, RECNO() returns the value at the position of the record
     pointer; the data type and other characteristics of this value are
     determined by the content of the accessed data and the RDD active in the
     current work area.  In an Xbase database this value is the record
     number.

 Examples

     USE Sales VIA "DBFNTX"
     .
     . < statements >
     .
     DBGOTOP()
     RECNO()            // Returns 1


Online resources provided by: http://www.X-Hacker.org --- NG 2 HTML conversion by Dave Pearson