DBRSELECT()

Purpose

Function to return the target workarea of a relation

Syntax

DBRSELECT(<expN>)

See Also

CREATE VIEW, DBRELATION(), SET RELATION, 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. 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