Difference between revisions of "TAGUNIQUE()"

From Lianjapedia
Jump to: navigation, search
 
Line 12: Line 12:
  
  
{| class="wikitable" width=100%
+
{| class="wikitable" width="100%"
!width=20%|Parameter||Description
+
!width="20%"|Parameter||Description
 
|-
 
|-
 
|<tagno>||The number of the tag
 
|<tagno>||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).

Latest revision as of 10:46, 5 February 2013

Purpose

Function to test whether an index tag is unique

Syntax

TAGUNIQUE(<tagno> [, <alias>])

See Also

INDEX, KEY(), MDX(), ORDER(), SET INDEX, SET ORDER, TAG(), TAGCOUNT(), TAGEXPR(), TAGFOR(), TAGKEY(), TAGNO(), USE

Description

The TAGUNIQUE() function returns .T. (true) if the specified index tag is unique and .F. (false) otherwise. 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. With no <alias> specified, the TAGUNIQUE() function operates in the currently selected workarea.


Parameter Description
<tagno> 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

open database southwind
use customers in 1
select 2
use orders
?tagunique(2,"customers")