Difference between revisions of "DBRELATION()"

From Recital Documentation Wiki
Jump to: navigation, search
Line 12: Line 12:
  
 
==Description==
 
==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.
+
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.  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.
  
  

Revision as of 16:37, 15 December 2009

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. 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 Server, Recital