Difference between revisions of "TAGKEY()"
From Lianjapedia
Yvonne.milne (Talk | contribs) |
Helen.george (Talk | contribs) |
||
Line 12: | Line 12: | ||
− | {| class="wikitable" width=100% | + | {| class="wikitable" width="100%" |
− | !width=20%|Parameter||Description | + | !width="20%"|Parameter||Description |
|- | |- | ||
|<tagno>||The number of the tag | |<tagno>||The number of the tag | ||
|- | |- | ||
− | |valign=top|<alias>||The workarea in which to operate. Specified in any of the following ways: | + | |valign="top"|<alias>||The workarea in which to operate. Specified in any of the following ways: |
A workarea number. | A workarea number. | ||
A workarea letter: A-Z (a-z) excluding M (m). | A workarea letter: A-Z (a-z) excluding M (m). |
Latest revision as of 10:45, 5 February 2013
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")