Difference between revisions of "TAG()"
Helen.george (Talk | contribs) |
Helen.george (Talk | contribs) |
||
| Line 11: | Line 11: | ||
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" width=100% | + | {| class="wikitable" width="100%" |
| − | !width=30%|Parameter||Description | + | !width="30%"|Parameter||Description |
|- | |- | ||
|<.dbx filename>||The .dbx file which contains the tag | |<.dbx filename>||The .dbx file which contains the tag | ||
| Line 18: | Line 18: | ||
|<expN>||The number of the tag | |<expN>||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). | ||
Revision as of 10:28, 4 February 2013
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
