Difference between revisions of "DBRSELECT()"

From Recital Documentation Wiki
Jump to: navigation, search
 
(Class)
Line 1: Line 1:
==Class==
 
Table Basics
 
  
  

Revision as of 14:58, 27 October 2009


Purpose

Function to return the target workarea of a relation


Syntax

DBRSELECT(<expN>)


See Also

CREATE BRIDGE, CREATE VIEW, DB_MAXWKA, 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. 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.


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 Database Server, Recital Mirage Server, Recital Terminal Developer