Difference between revisions of "TARGET()"
From Recital Documentation Wiki
Helengeorge (Talk | contribs) (→TARGET()) |
Helengeorge (Talk | contribs) (→Products) |
||
| Line 26: | Line 26: | ||
==Products== | ==Products== | ||
| − | Recital | + | Recital, Recital Server |
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Functions]] | [[Category:Functions]] | ||
Revision as of 16:42, 8 December 2009
Purpose
Function to return target workarea of a relation
Syntax
TARGET(<expN>)
See Also
Description
The TARGET() function is synonymous with the DBRSELECT() function. The TARGET() function returns the 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 are no relations defined for the <expN> on the currently selected table, the TARGET() function will return 0.
Example
use shows in 2 index people use patrons in 1 set relation to patron_code into shows ? target(1) 2
Products
Recital, Recital Server
