Difference between revisions of "TARGET()"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) |
Helengeorge (Talk | contribs) (→TARGET()) |
||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
==Purpose== | ==Purpose== | ||
Function to return target workarea of a relation | Function to return target workarea of a relation | ||
Revision as of 16:44, 28 October 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 Database Server, Recital Mirage Server, Recital Terminal Developer
