Difference between revisions of "RECNO()"
Yvonnemilne (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
| (4 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
==Purpose== | ==Purpose== | ||
Function to return current record number | Function to return current record number | ||
| Line 15: | Line 8: | ||
==See Also== | ==See Also== | ||
| − | [[BOF()]], [[EOF()]], [[FOUND()]], [[RECCOUNT()]] | + | [[ALIAS()]], [[BOF()]], [[CURSYNCNUM()]], [[DBF()]], [[EOF()]], [[FOUND()]], [[GOTO]], [[RECCOUNT()]], [[ROWNUM()]], [[SEEK]], [[SEEK()]], [[SELECT]], [[SELECT()]], [[SEQNO()]], [[SKIP]], [[SYNCNUM()]], [[UNIQUEROWID()]], [[USE]] |
| Line 34: | Line 27: | ||
==Products== | ==Products== | ||
| − | Recital | + | Recital, Recital Server |
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Functions]] | [[Category:Functions]] | ||
Latest revision as of 11:07, 5 July 2011
Purpose
Function to return current record number
Syntax
RECNO([<workarea | alias> [<expN>])
See Also
ALIAS(), BOF(), CURSYNCNUM(), DBF(), EOF(), FOUND(), GOTO, RECCOUNT(), ROWNUM(), SEEK, SEEK(), SELECT, SELECT(), SEQNO(), SKIP, SYNCNUM(), 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, Recital Server
