Difference between revisions of "TARGET()"

From Recital Documentation Wiki
Jump to: navigation, search
 
 
(2 intermediate revisions by one user not shown)
Line 1: Line 1:
=TARGET()=
 
 
 
==Class==
 
Table Basics
 
 
 
 
==Purpose==
 
==Purpose==
 
Function to return target workarea of a relation
 
Function to return target workarea of a relation
Line 19: Line 12:
  
 
==Description==
 
==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.
+
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.  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.
  
  
Line 33: Line 26:
  
 
==Products==
 
==Products==
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
+
Recital, Recital Server
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:Functions]]
 
[[Category:Functions]]

Latest revision as of 16:41, 15 December 2009

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. 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