LOOKUP()

From Lianjapedia
Revision as of 11:58, 7 December 2012 by Yvonne.milne (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Purpose

Function to perform a cross-table lookup

Syntax

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

See Also

KEYLOOKUP(), 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.

Example

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