Difference between revisions of "TAGNO()"
Helengeorge (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
| Line 23: | Line 23: | ||
|- | |- | ||
|<alias>||The workarea in which to operate. Specified in any of the following ways: | |<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). | ||
A table alias. The alias can be specified in the USE command. If not specified, the table basename is used. | A table alias. The alias can be specified in the USE command. If not specified, the table basename is used. | ||
|- | |- | ||
|} | |} | ||
| − | |||
Latest revision as of 16:40, 15 December 2009
Purpose
Function to return the number of an index tag
Syntax
TAGNO(<tag name>[,<.dbx filename>[,<alias>]])
See Also
KEY(), MDX(), ORDER(), TAG(), SET INDEX, SET ORDER, TAGCOUNT()
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
Products
Recital, Recital Server
