Difference between revisions of "DBRSELECT()"

From Recital Documentation Wiki
Jump to: navigation, search
 
(One intermediate revision by one user not shown)
Line 8: Line 8:
  
 
==See Also==
 
==See Also==
[[CREATE BRIDGE]], [[CREATE VIEW]], [[DB_MAXWKA]], [[DBRELATION()]], [[SET RELATION]], [[SET VIEW]], [[USE]]
+
[[CREATE BRIDGE]], [[CREATE VIEW]], [[DBRELATION()]], [[SET RELATION]], [[SET VIEW]], [[USE]]
  
  
 
==Description==
 
==Description==
The DBRSELECT() function is synonymous with the TARGET() function.  The DBRSELECT() function returns the numeric  target workarea of a specified relation defined in the current workarea.  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 <expN> is the position of the corresponding relation in the list of previously defined relations.  If there is no relation defined that matches the <expN> on the active table the DBRSELECT() function will return 0.
+
The DBRSELECT() function is synonymous with the TARGET() function.  The DBRSELECT() function returns the numeric  target workarea of a specified relation defined in the current workarea.  The <expN> is the position of the corresponding relation in the list of previously defined relations.  If there is no relation defined that matches the <expN> on the active table the DBRSELECT() function will return 0.
  
  

Latest revision as of 16:53, 15 December 2009

Purpose

Function to return the target workarea of a relation


Syntax

DBRSELECT(<expN>)


See Also

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


Description

The DBRSELECT() function is synonymous with the TARGET() function. The DBRSELECT() function returns the numeric target workarea of a specified relation defined in the current workarea. The <expN> is the position of the corresponding relation in the list of previously defined relations. If there is no relation defined that matches the <expN> on the active table the DBRSELECT() function will return 0.


Example

use shows in 2 index people
use patrons in 1
set relation to patron_code into shows
? dbrelation(1)
patron_code
? dbrselect(1)
         2


Products

Recital Server, Recital