Difference between revisions of "UNIQUE()"

From Recital Documentation Wiki
Jump to: navigation, search
 
(Products)
 
(3 intermediate revisions by 2 users not shown)
Line 1: Line 1:
=UNIQUE()=
 
 
 
==Class==
 
Indexing
 
 
 
 
==Purpose==
 
==Purpose==
 
Function to test for unique indexes
 
Function to test for unique indexes
Line 15: Line 8:
  
 
==See Also==
 
==See Also==
[[INDEXKEY()]], [[KEY()]], [[INDEXORDER()]], [[SET UNIQUE ON]], [[INDEX]]
+
[[INDEX]], [[INDEXKEY()]], [[INDEXORDER()]], [[KEY()]], [[SET UNIQUE]]  
  
  
Line 32: Line 25:
  
 
==Products==
 
==Products==
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
+
Recital, Recital Server
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:Functions]]
 
[[Category:Functions]]
 +
[[Category:Indexing]]
 +
[[Category:Indexing Functions]]

Latest revision as of 16:45, 8 December 2009

Purpose

Function to test for unique indexes


Syntax

UNIQUE(<expN>)


See Also

INDEX, INDEXKEY(), INDEXORDER(), KEY(), SET UNIQUE


Description

The UNIQUE() function returns .T. if the specified index <expN> is unique, and .F. if it is not unique. <expN> is the index number from 0 to 20. If zero is specified then UNIQUE() tests the master index. For tagged multiple indexes, only the master index can be tested.


Example

use accounts
index on name to name unique
? unique(0)
.T.


Products

Recital, Recital Server