TAGCOUNT()

From Recital Documentation Wiki
Revision as of 16:31, 8 December 2009 by Helengeorge (Talk | contribs)

Jump to: navigation, search

Purpose

Function to count the number of tags in the active .dbx file


Syntax

TAGCOUNT([<.dbx filename> [,<alias>]])


See Also

KEY(), MDX(), TAG(), TAGNO()


Description

The TAGCOUNT() function returns the number of tags in a particular .dbx file. With no parameters, the TAGCOUNT() function operates on the currently active .dbx file in the currently selected workarea. A .dbx file is active if one of the tags contained within the .dbx file is the master index order. The TAGCOUNT() function will return a zero if the file is a single (.ndx) file or if there are no indexes active.


Parameter Description
<.dbx filename> The .dbx file which contains the tag. This must be specified if the <alias> is used.
<alias> The workarea in which to operate. Specified in any of the following ways:

A workarea number: 1-DB_MAXWKA 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

use accounts
? tagcount()
          4
set order to 0
?tagcount()
         0


Products

Recital, Recital Server