Difference between revisions of "NDX()"
From Lianjapedia
Yvonne.milne (Talk | contribs) |
|||
(2 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
Function to return index file name | Function to return index file name | ||
− | |||
==Syntax== | ==Syntax== | ||
NDX(<expN>) | NDX(<expN>) | ||
− | |||
==See Also== | ==See Also== | ||
− | [[DBF | + | [[DBF()]], [[INDEXKEY()]], [[INDEXORDER()]], [[SET FILECASE]], [[SET FULLPATH]] |
− | + | ||
==Description== | ==Description== | ||
The NDX() function returns, in lower case, the name of the index file <expN> for the table in the currently selected workarea. If the table is not indexed, then NDX() returns a null string. When used in conjunction with the INDEXORDER() function, the NDX() function will return the index file name of the master index. | The NDX() function returns, in lower case, the name of the index file <expN> for the table in the currently selected workarea. If the table is not indexed, then NDX() returns a null string. When used in conjunction with the INDEXORDER() function, the NDX() function will return the index file name of the master index. | ||
− | |||
− | |||
− | |||
==Example== | ==Example== | ||
Line 27: | Line 21: | ||
</code> | </code> | ||
− | |||
− | |||
− | |||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Functions]] | [[Category:Functions]] | ||
− | [[Category: | + | [[Category:Cursor Functions]] |
− | [[Category: | + | [[Category:Search Functions]] |
Latest revision as of 11:17, 4 February 2013
Contents
Purpose
Function to return index file name
Syntax
NDX(<expN>)
See Also
DBF(), INDEXKEY(), INDEXORDER(), SET FILECASE, SET FULLPATH
Description
The NDX() function returns, in lower case, the name of the index file <expN> for the table in the currently selected workarea. If the table is not indexed, then NDX() returns a null string. When used in conjunction with the INDEXORDER() function, the NDX() function will return the index file name of the master index.
Example
use accounts index acc_no,date_paid ? ndx(1) acc_no.ndx set order to 2 ? ndx(indexorder()) date_paid.ndx