TAGCOUNT()

From Lianjapedia
Jump to: navigation, search

Purpose

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

Syntax

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

See Also

CREATE INDEX, INDEX, 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. 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