Difference between revisions of "REFERENCES()"

From Recital Documentation Wiki
Jump to: navigation, search
 
(2 intermediate revisions by 2 users not shown)
Line 1: Line 1:
==Class==
 
Indexing
 
 
 
 
==Purpose==
 
==Purpose==
 
Function to perform a cross-table lookup for a specified key expression
 
Function to perform a cross-table lookup for a specified key expression
Line 12: Line 8:
  
 
==See Also==
 
==See Also==
[[ALIAS()]], [[FIND]], [[INDEX]], [[KEY()]], [[LOOKUP()]], [[RLOOKUP()]], [[SEEK]], [[SEEK()]], [[SET RELATION]], [[TAG()]], [[TAGCOUNT()]], [[TAGNO()]]  
+
[[ALIAS()]], [[FIND]], [[INDEX]], [[KEY()]], [[KEYMATCH()]], [[LOOKUP()]], [[RLOOKUP()]], [[SEEK]], [[SEEK()]], [[SET RELATION]], [[TAG()]], [[TAGCOUNT()]], [[TAGNO()]]  
  
  
Line 35: Line 31:
  
 
==Products==
 
==Products==
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
+
Recital, Recital Server
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:Functions]]
 
[[Category:Functions]]

Latest revision as of 15:12, 7 December 2009

Purpose

Function to perform a cross-table lookup for a specified key expression


Syntax

REFERENCES(<key expression>, <workarea | alias> [,<tag name>])


See Also

ALIAS(), FIND, INDEX, KEY(), KEYMATCH(), LOOKUP(), RLOOKUP(), SEEK, SEEK(), SET RELATION, TAG(), TAGCOUNT(), TAGNO()


Description

The REFERENCES() function looks up the specified <key expression> in the master tag index of the specified <workarea | alias>. The <workarea | alias> is the workarea or alias name of an open table. To search in a tag index which is not the current master index, the optional <tag name> parameter can be used. The tag name must be specified as a string.

The REFERENCES() function returns True (.T.) or False (.F.), depending on the success of the lookup operation.

Please see the RLOOKUP() function for cross-table lookups using single indexes (.ndx).


Example

use customer.rdb
index on account_no tag account_no
index on upper(last_name) tag uplast
index on zip tag zip
? references("STEREK",customer,"uplast")
.T.


Products

Recital, Recital Server