ATAGINFO()
From Lianjapedia
Contents
Purpose
Function to create an array to return information about the indexes of the current table
Syntax
ATAGINFO(<arrayname>)
See Also
ALTER TABLE, ALTER VIRTUALTABLE, CREATE TABLE, CREATE VIEW, CREATE VIRTUALTABLE, DBF(), FILEINFO(), INDEXEXISTS(), KEY(), MDX(), NDX(), ORDER(), SELECT, TABLEINFO(), TAGCOUNT(), TAGNO()
Description
The ATAGINFO() creates the two-dimensional array <arrayname> and populates it with information about the indexes of the current table.
For each index, the array contains the following six elements:
- Tag name
- Data type
- Key
- For condition
- Sorting direction
- Character encoding
Example
open database southwind use shippers ataginfo(aShiptags) ASHIPTAGS Fixed array (refcnt 1) ASHIPTAGS [1,1] pri( 1) Character[ 9] 'SHIPPERID' ASHIPTAGS [1,2] pri( 1) Character[ 1] 'N' ASHIPTAGS [1,3] pri( 1) Character[ 9] 'shipperid' ASHIPTAGS [1,4] pri( 1) Character[ 0] '' ASHIPTAGS [1,5] pri( 1) Character[ 9] 'ascending' ASHIPTAGS [1,6] pri( 1) Character[ 5] 'utf-8' ASHIPTAGS [2,1] pri( 1) Character[ 18] 'COMPANYNAME_SEARCH' ASHIPTAGS [2,2] pri( 1) Character[ 1] 'C' ASHIPTAGS [2,3] pri( 1) Character[ 27] 'LOWER(SHIPPERS.COMPANYNAME)' ASHIPTAGS [2,4] pri( 1) Character[ 0] '' ASHIPTAGS [2,5] pri( 1) Character[ 9] 'ascending' ASHIPTAGS [2,6] pri( 1) Character[ 5] 'utf-8' ASHIPTAGS [3,1] pri( 1) Character[ 19] 'COMPANYNAME_REVERSE' ASHIPTAGS [3,2] pri( 1) Character[ 1] 'C' ASHIPTAGS [3,3] pri( 1) Character[ 20] 'reverse(companyname)' ASHIPTAGS [3,4] pri( 1) Character[ 0] '' ASHIPTAGS [3,5] pri( 1) Character[ 9] 'ascending' ASHIPTAGS [3,6] pri( 1) Character[ 5] 'utf-8' ASHIPTAGS [4,1] pri( 1) Character[ 16] 'SHIPPERID_SEARCH' ASHIPTAGS [4,2] pri( 1) Character[ 1] 'N' ASHIPTAGS [4,3] pri( 1) Character[ 18] 'SHIPPERS.SHIPPERID' ASHIPTAGS [4,4] pri( 1) Character[ 0] '' ASHIPTAGS [4,5] pri( 1) Character[ 9] 'ascending' ASHIPTAGS [4,6] pri( 1) Character[ 5] 'utf-8'