Returns index expression of an open single-entry .idx index file or index expressions for tags in compound .cdx index files.

SYS(14, nIndexNumber [, nWorkArea | cTableAlias])

Parameters

nIndexNumber

Specifies which index expression to return from the open index files or tags. SYS(14) returns index expressions from open index files and tags in the following order as nIndexNumber increases from 1 to the total number of open single-entry files and structural compound and independent compound index tags:

1. Index expressions from single-entry index files (if any are open) are returned first. The order the single-entry index files are included in USE or SET INDEX determines the order the index expressions are returned.

2. Index expressions for each tag in the structural compound index (if one is present) are returned next. The index expressions are returned from the tags in the order that the tags were created in the structural index.

3. Index expressions for each tag in any open independent compound indexes are returned last. The index expressions are returned from the tags in the order that the tags were created in the independent compound indexes.

The empty string is returned if nIndexNumber is greater than the total number of open single-entry files and structural compound and independent compound index tags.

nWorkArea| cTableAlias

Specifies a work area number or work area alias. If you omit nWorkArea and cTableAlias, index expressions are returned from index files open in the current work area. If a table doesn't have the alias you specify, Visual FoxPro generates an error message.

Return Value

Remarks

See Also

Reference

ATAGINFO( ) Function
CDX( ) Function
INDEX Command
KEY( ) Function
MDX( ) Function
NDX( ) Function
REINDEX Command
SET INDEX Command
SET ORDER Command
SYS( ) Functions Overview
TAG( ) Function
TAGCOUNT( ) Function
TAGNO( ) Function

Other Resources

Index Manipulation Language