TARGET()

From Recital Documentation Wiki
Revision as of 15:10, 20 March 2009 by Yvonnemilne (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

TARGET()

Class

Table Basics


Purpose

Function to return target workarea of a relation


Syntax

TARGET(<expN>)


See Also

DBRSELECT(), SET RELATION


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