CDX( ) Function

Returns the names of the open compound index (.cdx) file that has the specified index position number.

CDX(nIndexNumber [, nWorkArea | cTableAlias])

Parameters

nIndexNumber

The following apply to a table with a structural compound index and one or more compound indexes:

nIndexNumber Description

1

Returns the name of the structural index file (which is always the same as the name of the table).

2

Returns the first compound index file name specified in the INDEX clause of USE or in SET INDEX.

3

Returns the second compound index file name, if any, and so on.

Greater than the number of open .cdx files

Returns the empty string.

The following apply to a table with no structural compound index and one or more compound indexes:

nIndexNumber Description

1

Returns the first compound index file name specified in the INDEX clause of USE or in SET INDEX.

2

Returns the second compound index file name, if any, and so on.

Greater than the number of open .cdx files

Returns the empty string.

nWorkArea

Specifies the work area number of a table whose open compound index file names you want CDX( ) to return.

cTableAlias

Specifies the alias of a table whose open compound index file names you want CDX( ) to return.

If you omit nWorkArea and cTableAlias, names of compound index files are returned for the table in the currently selected work area.

Expand imageReturn Value

Expand imageRemarks

Expand image Example

Expand imageSee Also


© , 1996-2020 • Updated: 11/10/20
Comment or report problem with topic