NDX()

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