ATAGINFO()

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'