TAGKEY()

From Lianjapedia
Jump to: navigation, search

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")