Difference between revisions of "DBRSELECT()"
Helengeorge (Talk | contribs) (→Class) |
Helengeorge (Talk | contribs) |
||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
==Purpose== | ==Purpose== | ||
Function to return the target workarea of a relation | Function to return the target workarea of a relation | ||
| Line 30: | Line 28: | ||
==Products== | ==Products== | ||
| − | Recital | + | Recital Server, Recital |
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Functions]] | [[Category:Functions]] | ||
Revision as of 16:44, 27 November 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 Server, Recital
