TAGKEY()
From Lianjapedia
Revision as of 10:45, 5 February 2013 by Helen.george (Talk | contribs)
Contents
Purpose
Function to return the key expression of an index tag
Syntax
TAGKEY(<tagno> [, <alias>])
See Also
KEY(), MDX(), ORDER(), SET INDEX, SET ORDER, TAG(), TAGCOUNT(), TAGEXPR(), TAGFOR(), TAGNO(), TAGUNIQUE()
Description
The TAGKEY() function returns the key expression for the specified index tag. Tag numbers are assigned as they are added to multiple index files. The first tag added is number 1, the second is number 2, and so on. With no <alias> specified, the TAGKEY() function operates in the currently selected workarea.
Parameter | Description |
---|---|
<tagno> | The number of the tag |
<alias> | The workarea in which to operate. Specified in any of the following ways:
A workarea number. A workarea letter: A-Z (a-z) excluding M (m). A table alias. The alias can be specified in the USE command. If not specified, the table basename is used. |
Example
open database southwind use customers in 1 select 2 use orders ?tagkey(2,"customers")