MDX()

From Lianjapedia
Revision as of 11:17, 4 February 2013 by Yvonne.milne (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Purpose

Function to return the active multiple index filename

Syntax

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

See Also

CDX(), DISPLAY INDEXES, FOR(), KEY(), LIST INDEXES, NDX(), ORDER(), SET(), SET FILECASE, SET FULLPATH, TAG(), TAGCOUNT(), TAGNO(),

Description

The MDX() function returns the name of the currently open multiple index file. Used without any parameters, the MDX() function will return the name of the multiple index file in the current workarea. If there is no .dbx file in the workarea, the MDX() function will return a null string. The optional numeric expression, <expN>, may be used to return the .dbx file name for a specific tag number. This parameter is needed if more than one .dbx file is open in a workarea. You may optionally specify an alias to use the MDX() function in other workareas. The <alias> may be a workarea number or letter or the table alias name.

Example

?mdx(1, account)
invoice.dbx