MDX( )

Topic group Related topics Example

Returns the names of a DBF table’s open .MDX index files.

Syntax

MDX([<mdx expN>[, <alias>]])

<mdx expN>

A number indicating which open .MDX file whose name to return.

<alias>

The work area you want to check.

Description

MDX( ) returns the name of an .MDX file open in the current or specified work area. .MDX files are numbered in the order in which they were opened. The production .MDX file, the one with the same name as the DBF file, is number 1.

If <mdx expN> is omitted, the name of the .MDX file containing the current master index tag is returned.

MDX( ) includes the drive letter (and colon) in the filename. If SET FULLPATH is ON, MDX( ) also returns the directory location of the .MDX file in addition to the drive and name.

If <mdx expN> is higher than the number of open .MDX files, or if you do not specify an index order number and the master index is an .NDX file, MDX( ) returns an empty string (""). MDX( ) also returns an empty string if there is no .MDX file open.

OODML

No equivalent.