DbRelation Function

Return the linking expression of a specified relation.

Namespace: XSharp.RT
Assembly: XSharp.RT (in XSharp.RT.dll) Version: 2.19

Syntax

 FUNCTION DbRelation(
	nRelation
) AS STRING CLIPPER

[ClipperCallingConventionAttribute(new string[] { ... })]
public static string DbRelation(
	Usual nRelation = default
)

Request Example View Source

Parameters

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

Return Value

Type: String
The linking expression defined to nRelation.
If there is no relation set for nRelation, DBRelation() returns a NULL_STRING.

Remarks

DBRelation() is a database function to determine the linking expression and work area of an existing relation. DBRelation() returns the linking expression defined by the TO clause. DBRSelect() returns the work area linked as defined by the INTO clause. By default, this function operates on the currently selected work area.
It can be made to operate on an unselected work area by specifying it within an aliased expression

Tip
Declared variables: A string returned by DBRelation() cannot operate correctly when recompiled and executed using the macro operator (&) if the original expression contained references to local or static variables, or otherwise depends on compile-time declarations.

Examples

This example opens three database files, sets two child relations from the parent work area, and then displays the linking expression to the second child work area:

Copy

1USE invoices INDEX invoices NEW
2USE backorder INDEX backorder NEW
3USE customer INDEX customer NEW
4SET RELATION TO custnum INTO invoices, OrderNum ;
5        INTO backorder
6QOut(DBRelation(2))                // Result: Ordernum

Later you can query the same linking expression from an unselected work area by using an aliased expression like this:

Copy

1USE archive NEW
2QOut(Customer->DBRelation(2))
3// Result: OrderNum

This example is a function, Relation(), that returns the results of both DBRelation() and DBRSelect() as an array:

Copy

1FUNCTION Relation(nRelation)
2    RETURN {;
3                DBRelation(nRelation), ;
4                Alias(DBRSelect(nRelation)) ;
5            }

Reference

Functions, Globals and Defines

VoDbRelation(DWord, String)