TAGNO()

From Lianjapedia
Jump to: navigation, search

Purpose

Function to return the number of an index tag

Syntax

TAGNO(<tag name>[,<.dbx filename>[,<alias>]])

See Also

KEY(), MDX(), ORDER(), SET INDEX, SET ORDER, TAG(), TAGCOUNT(), TAGEXPR(), TAGFOR(), TAGKEY(), TAGUNIQUE()

Description

The TAGNO() function returns the tag number 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. If more than one .dbx file is active, tag numbers are assigned sequentially starting with the first production index tag unless there are single (.ndx) index files active in the workarea. In this case, all .ndx files will be given a tag number first, then tags in the production index will be numbered. Non production .dbx files will be assigned tag numbers last. With no <alias> specified, the TAGNO() function operates in the currently selected workarea.


Parameter Description
<tag name> The name of the tag
<.dbx filename> The .dbx file which contains the tag. Only required if the same tag name exists in multiple .dbx files or the <alias> is specified..
<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

?tagno("city")
         3
?tagno("last_name", "customer.dbx", "customer")
         1