Difference between revisions of "DBRELATION()"

Revision as of 16:40, 23 March 2009

Class

Table Basics

Purpose

Function to return table-linking expression

Syntax

DBRELATION(<expN>)

See Also

CREATE BRIDGE, CREATE VIEW, DB_MAXWKA, DBRSELECT(), RELATION(), SET RELATION, SET VIEW, TARGET(), USE

Description

The DBRELATION() function is synonymous with the RELATION() function. The DBRELATION() 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. By default, the Recital environment supports 20 workareas but this can be increased, by setting the environment symbol DB_MAXWKA to a higher value, which allows for up to (DB_MAXWKA-1) relationships. The DBRELATION() 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
? dbrelation(1)
patron_code
? target(1)
         2

Products

Recital Database Server, Recital Mirage Server, Recital Terminal Developer