Difference between revisions of "NDX()"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) |
Helengeorge (Talk | contribs) |
||
| (2 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
| − | |||
| − | |||
==Purpose== | ==Purpose== | ||
Function to return index file name | Function to return index file name | ||
| Line 33: | Line 29: | ||
==Products== | ==Products== | ||
| − | Recital | + | Recital, Recital Server |
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Functions]] | [[Category:Functions]] | ||
| + | [[Category:Indexing]] | ||
| + | [[Category:Indexing Functions]] | ||
Latest revision as of 17:20, 3 December 2009
Purpose
Function to return index file name
Syntax
NDX(<expN>)
See Also
DBF(), FMT(), INDEXKEY(), INDEXORDER(), SET COMPATIBLE, 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.
If SET COMPATIBLE is set to FOXPRO or VFP the NDX() return value format differs in the following way: if SET FULLPATH is ON the full path to the index file is returned, if SET FILECASE is OFF then the return value is converted to upper case (Windows only).
Example
use accounts index acc_no,date_paid ? ndx(1) acc_no.ndx set order to 2 ? ndx(indexorder()) date_paid.ndx
Products
Recital, Recital Server
