Difference between revisions of "REFERENCES()"
Yvonne.milne (Talk | contribs) m (1 revision) |
Yvonne.milne (Talk | contribs) |
||
Line 1: | Line 1: | ||
==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 | ||
− | |||
==Syntax== | ==Syntax== | ||
REFERENCES(<key expression>, <workarea | alias> [,<tag name>]) | REFERENCES(<key expression>, <workarea | alias> [,<tag name>]) | ||
− | |||
==See Also== | ==See Also== | ||
− | [[ALIAS() | + | [[ALIAS()]], [[INDEX]], [[KEY()]], [[KEYMATCH()]], [[LOOKUP()]], [[RLOOKUP()]], [[SEEK]], [[SEEK()]], [[SET RELATION]], [[TAG()]], [[TAGCOUNT()]], [[TAGNO()]] |
− | + | ||
==Description== | ==Description== | ||
Line 17: | Line 14: | ||
Please see the RLOOKUP() function for cross-table lookups using single indexes (.ndx). | Please see the RLOOKUP() function for cross-table lookups using single indexes (.ndx). | ||
− | |||
==Example== | ==Example== | ||
Line 29: | Line 25: | ||
</code> | </code> | ||
− | |||
− | |||
− | |||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Functions]] | [[Category:Functions]] |
Revision as of 06:00, 10 February 2012
Contents
Purpose
Function to perform a cross-table lookup for a specified key expression
Syntax
REFERENCES(<key expression>, <workarea | alias> [,<tag name>])
See Also
ALIAS(), 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.