Click or drag to resize

DbRSelect Function

Return the work area number of a relation.

Namespace:  XSharp.RT
Assembly:  XSharp.RT (in XSharp.RT.dll) Version: 2.08
Syntax
 FUNCTION DbRSelect(
	 nRelation AS USUAL
) AS DWORD
View Source

Parameters

nRelation
Type: Usual
The position of the desired relation in the list of work area relations.  The relations are numbered according to the order in which they were defined by relation setting.

Return Value

Type: UInt32
The work area number of the specified relation.  If there is no relation set for <nRelation>, DBRSelect() returns 0.
Remarks
DBRSelect() is a database function used in combination with DBRelation() to determine the work area and linking expression of an existing relation.  DBRSelect() returns the work area defined by the INTO clause.  DBRelation() returns the linking expression defined by the TO clause.  To determine the alias of the relation instead of the work area number, use the expression Alias(DBRSelect(<nRelation>)). By default, DBRSelect() operates on the currently selected work area.  It will operate on an unselected work area if you specify it as part of an aliased expression (see example below).
Examples
This example opens three database files, sets two child relations from the parent work area, then displays the linking expression to the second child work area as well as the target work area of the relation:
X#
USE invoices INDEX invoices NEW
USE backorder INDEX backorder NEW
USE customer INDEX customer NEW
SET RELATION TO custnum INTO customer, ;
                Ordernum INTO Backorder
QOut(DBRelation(2), DBRSelect(2))
// Result: Ordernum 3
QOut(Alias(DBRSelect(2))
// Result: BackOrder
Later you can query the same information from an unselected work area by using an aliased expression:
X#
USE archive NEW
QOut(Customer->DBRelation(2))
// Result: Ordernum
QOut(Customer->DBRSelect(2))
// Result: 3
See Also