RELATION()

Purpose

Function to return table-linking expression

Syntax

RELATION(<expN>)

See Also

CREATE VIEW, DBRELATION(), DBRSELECT(), SET RELATION, TARGET(), USE

Description

The RELATION() function is synonymous with the DBRELATION() function. The RELATION() function returns the linking expression of a specified relation in the current workarea. The <expN> specifies the position of the desired linking expression from the list of previously defined relations. The RELATION() function always returns a character string in lower case. If there is no linking expression defined for the <expN> selected, a null string will be returned.

Example

use shows in 2 index pcode
use patrons in 1
set relation to patron_code into shows
? relation(1)
patron_code
? target(1)
         2