Click or drag to resize

Mdx Function

X#
Returns the name of the open .cdx compound index file that has the specified index position number.

Namespace:  XSharp.VFP
Assembly:  XSharp.VFP (in XSharp.VFP.dll) Version: 2.19
Syntax
 FUNCTION Mdx(
	nIndexNumber,
	uArea
) AS STRING CLIPPER
Request Example View Source

Parameters

nIndexNumber (Optional)
Type: Usual
Specifies which compound index file name to return. If the table has a structural compound index file and nIndexNumber is 1, the name of the structural compound index file (which is always the same as the name of the table) is returned. If nIndexNumber is 2, the name of the first compound index file specified with Use or Set Index is returned. If nIndexNumber is 3, the second compound index file name is returned, and so on. If nIndexNumber is greater than the number of open compound index files, an empty string is returned. If the table doesn't have a structural compound index file and nIndexNumber is 1, the name of the first compound index file specified with Use or Set Index is returned. If nIndexNumber is 2, the second compound index file name is returned, and so on. If nIndexNumber is greater than the number of open compound index files, an empty string is returned.
uArea (Optional)
Type: Usual
Specifies the work area number for compound index files open in work areas other than the current one. If you omit this optional argument, names of compound index files are returned for the current work area.
Or
Specifies the table alias for compound index files open in work areas other than the current one. If you omit this optional argument, names of compound index files are returned for the current work area.

Return Value

Type: String
Character
Remarks
MDX( ) is identical to CDX( ). Index files can be opened for a table with the Index clause of the Use command or with Set Index. A structural compound index file is automatically opened with its table. MDX( ) ignores any .idx index files specified with Use or with Set Index. Use TAG( ) to return tag names from a compound index file; use NDX( ) to return the name of an open .idx index file. In X# for Windows, when Set FullPath is ON, MDX( ) returns the path to the .cdx file with the .cdx file name. When Set FullPath is OFF, MDX( ) returns the drive the .cdx file resides on with the .cdx file name.
See Also