Difference between revisions of "TAG()"
m (Text replace - "Recital" to "Lianja") |
Helen.george (Talk | contribs) |
||
| Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
Function to return the name of an index file or index tag | Function to return the name of an index file or index tag | ||
| − | |||
==Syntax== | ==Syntax== | ||
TAG([<.dbx filename>,] [<expN> [, <alias>]]) | TAG([<.dbx filename>,] [<expN> [, <alias>]]) | ||
| − | |||
==See Also== | ==See Also== | ||
[[DBF()]], [[KEY()]], [[MDX()]], [[NDX()]], [[ORDER()]], [[TAGCOUNT()]], [[TAGNO()]] | [[DBF()]], [[KEY()]], [[MDX()]], [[NDX()]], [[ORDER()]], [[TAGCOUNT()]], [[TAGNO()]] | ||
| − | |||
==Description== | ==Description== | ||
The TAG() function returns the tag name of the specified .dbx file, or the filename of a single (.ndx) file. With no parameters, the TAG() function operates in the current workarea on the master index. If the optional <.dbx filename> is not specified, one of its tags must be the master index order for its tag names to be queried. If no indexes are active or the specified index is not active, TAG() will return a null string. An error will be given if an invalid alias name is given. | The TAG() function returns the tag name of the specified .dbx file, or the filename of a single (.ndx) file. With no parameters, the TAG() function operates in the current workarea on the master index. If the optional <.dbx filename> is not specified, one of its tags must be the master index order for its tag names to be queried. If no indexes are active or the specified index is not active, TAG() will return a null string. An error will be given if an invalid alias name is given. | ||
| − | |||
{| class="wikitable" | {| class="wikitable" | ||
| Line 28: | Line 24: | ||
|- | |- | ||
|} | |} | ||
| − | |||
==Example== | ==Example== | ||
| Line 37: | Line 32: | ||
ZIPCODE | ZIPCODE | ||
</code> | </code> | ||
| − | |||
==Products== | ==Products== | ||
Revision as of 11:18, 12 December 2012
Purpose
Function to return the name of an index file or index tag
Syntax
TAG([<.dbx filename>,] [<expN> [, <alias>]])
See Also
DBF(), KEY(), MDX(), NDX(), ORDER(), TAGCOUNT(), TAGNO()
Description
The TAG() function returns the tag name of the specified .dbx file, or the filename of a single (.ndx) file. With no parameters, the TAG() function operates in the current workarea on the master index. If the optional <.dbx filename> is not specified, one of its tags must be the master index order for its tag names to be queried. If no indexes are active or the specified index is not active, TAG() will return a null string. An error will be given if an invalid alias name is given.
| Parameter | Description |
|---|---|
| <.dbx filename> | The .dbx file which contains the tag |
| <expN> | 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
?tag(2) LAST_NAME tag("alternate.dbx",3) ZIPCODE
Products
Lianja, Lianja Server
