+---------------------------------+
|               NDX               |
+---------------------------------+
NDX(<expN1> [, <expN2> | <expC>])

-----------------------------------
Returns name of open .IDX index.
Return value - Character.
-----------------------------------

NDX() returns the name of an open single-entry .IDX index file.  The
CDX() and MDX() functions may be used to return the names of open .CDX
compound index files.

<expN1>
        USE and SET INDEX both support an index file list that lets you open
index files for a database.  The index file name returned by this
function is determined by its placement in this index file list.  For
example, if <expN1> is 1 the name of the first index file in the index
file list is returned, if <expN1> is 2 the second index name is returned
and so on.  Any compound .CDX index files in the index file list are
ignored.

        If <expN1> is greater than the number of .IDX indexes in the index file
list, the null string is returned.

<expN2> | <expC>
        If you don't specify a work area or alias, the names of .IDX index
files open with the database in the currently selected work area are
returned.

        You can return names of .IDX index files open in other work areas by
specifying the work area number <expN2>, or the database alias <expC>.

        If a database isn't open in the work area you specify, NDX() returns
the null string.  If a database doesn't have the alias you include, the
message "Alias not found." is displayed.

-----------------------------------

See Also:  CDX(), MDX(), SET INDEX, SYS(14) Index expression, SYS(21)
Master index number, SYS(22) Master tag/index name, SYS(2021) Filtered
index expr, TAG(), USE

-----------------------------------