Difference between revisions of "TAGCOUNT()"

From Lianjapedia
Jump to: navigation, search
 
Line 6: Line 6:
  
 
==See Also==
 
==See Also==
[[INDEX]], [[KEY()]], [[MDX()]], [[TAG()]], [[TAGNO()]]
+
[[CREATE INDEX]], [[INDEX]], [[KEY()]], [[MDX()]], [[TAG()]], [[TAGNO()]]
  
 
==Description==
 
==Description==

Latest revision as of 05:51, 16 July 2013

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