Difference between revisions of "RECNO()"
Yvonne.milne (Talk | contribs) m (1 revision) |
Yvonne.milne (Talk | contribs) |
||
(3 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 | ||
− | |||
==Syntax== | ==Syntax== | ||
− | RECNO([<workarea | alias> [<expN>]) | + | RECNO([<workarea | alias> [<expN>]]) |
− | + | ||
==See Also== | ==See Also== | ||
[[ALIAS()]], [[BOF()]], [[CURSYNCNUM()]], [[DBF()]], [[EOF()]], [[FOUND()]], [[GOTO]], [[RECCOUNT()]], [[ROWNUM()]], [[SEEK]], [[SEEK()]], [[SELECT]], [[SELECT()]], [[SEQNO()]], [[SKIP]], [[SYNCNUM()]], [[UNIQUEROWID()]], [[USE]] | [[ALIAS()]], [[BOF()]], [[CURSYNCNUM()]], [[DBF()]], [[EOF()]], [[FOUND()]], [[GOTO]], [[RECCOUNT()]], [[ROWNUM()]], [[SEEK]], [[SEEK()]], [[SELECT]], [[SELECT()]], [[SEQNO()]], [[SKIP]], [[SYNCNUM()]], [[UNIQUEROWID()]], [[USE]] | ||
− | |||
==Description== | ==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. | 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== | ==Example== | ||
Line 26: | Line 22: | ||
− | |||
− | |||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Functions]] | [[Category:Functions]] | ||
+ | [[Category:Cursor Functions]] |
Latest revision as of 05:39, 14 October 2016
Contents
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