Difference between revisions of "CDX()"

Revision as of 15:04, 2 June 2009

Class

Indexing

Purpose

Function to return the active multiple index filename

Syntax

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

See Also

DB_MAXWKA, FOR(), KEY(), NDX(), ORDER(), SET(), SET COMPATIBLE, SET FILECASE, SET FULLPATH, TAG(), TAGCOUNT(), TAGNO()

Description

The CDX() function returns the name of the currently open multiple index file. Used without any parameters, the CDX() function will return the name of the multiple index file in the current workarea. If there is no .dbx file in the workarea, the CDX() 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 name to use the CDX() function in other workareas. The <alias> may be a workarea number or letter (1-DB_MAXWKA, a-z) or the table alias name.

If SET COMPATIBLE is set to FOXPRO or VFP the CDX() return value format differs in the following way: if SET FULLPATH is ON the full path to the index file is returned, if SET FILECASE is OFF then the return value is converted to upper case (Windows only).

Example

?cdx(1, account)
invoice.dbx

Products

Recital Database Server, Recital Mirage Server, Recital Terminal Developer