Creates an array that contains information about index files for the selected table.
ATAGINFO(ArrayName [,cCDXName [, nWorkArea | cTableAlias]]) |
Parameters
- ArrayName
- Specifies the name of the array to create. Visual FoxPro creates the array if it does not already exist.
- cCDXName
-
Specifies the name of the compound index (.cdx) file to return information for.
Note: Specifying an empty string ("") returns the number of tags in all open .cdx files and all open standalone index (.idx) files for the selected table.
- nWorkArea
- Specifies the work area that contains the table to returns information for.
- cTableAlias
-
Specifies the alias of the table to return information for.
Note: Omitting cTableAlias and nWorkArea uses the table in the current work area.
Return Value
Numeric. ATAGINFO(В ) returns the number of index tags in compound index (.cdx) files or open single-key standalone index (.idx) files for the current table.
Remarks
The following table describes the information stored in the array that ATAGINFO(В ) creates.
Column | Description | Data type |
---|---|---|
1 |
Index tag name in a .cdx file or index file name for .idx files |
Character |
2 |
Index tag type |
Character |
3 |
Index key expression |
Character |
4 |
Filter expression |
Character |
5 |
Index order as created (Ascending or Descending) |
Character |
6 |
Collate sequence |
Character |