Difference between revisions of "LOOKUP()"

From Recital Documentation Wiki
Jump to: navigation, search
 
 
(One intermediate revision by one user not shown)
Line 1: Line 1:
==Class==
 
Fields and Records
 
 
 
 
==Purpose==
 
==Purpose==
 
Function to perform a cross-table lookup
 
Function to perform a cross-table lookup
Line 29: Line 25:
  
 
==Products==
 
==Products==
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
+
Recital Server, Recital  
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:Functions]]
 
[[Category:Functions]]

Latest revision as of 17:08, 2 December 2009

Purpose

Function to perform a cross-table lookup


Syntax

LOOKUP(<exp>, <key expression>, <workarea | alias>)


See Also

CREATE, MODIFY STRUCTURE, RLOOKUP(), SEEK(), SET RELATION


Description

The LOOKUP() function looks up the specified index <key expression> in the master index of specified <workarea | alias>. The LOOKUP() function then evaluates the expression <exp>, and returns the value of the <exp> if the <key expression> is found. The LOOKUP() function returns a null string if the <key expression> is not found. The lookup function can be very useful for dealing with calculated expressions in either the Application Data Dictionary or the Forms Designer.


Example

use depts in 2 index dnum
use funcs in 1 index funcno
? lookup(depts->dname,funcs->dnum,depts)
Research and Development


Products

Recital Server, Recital