Difference between revisions of "RELATION()"

From Recital Documentation Wiki
Jump to: navigation, search
 
(Products)
 
(One intermediate revision by one user not shown)
Line 1: Line 1:
=RELATION()=
 
 
 
==Class==
 
Table Basics
 
 
 
 
==Purpose==
 
==Purpose==
 
Function to return table-linking expression
 
Function to return table-linking expression
Line 35: Line 28:
  
 
==Products==
 
==Products==
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
+
Recital, Recital Server
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:Functions]]
 
[[Category:Functions]]

Latest revision as of 15:11, 7 December 2009

Purpose

Function to return table-linking expression


Syntax

RELATION(<expN>)


See Also

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


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. 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 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


Products

Recital, Recital Server