Click or drag to resize

SQLTable.SetSelectiveRelation Method (Typed)

X#
Set a selective relation from this server to the child server; standard database operations are restricted to those records that match the relation.

Namespace:  XSharp.VO.SDK
Assembly:  XSharp.VOSQLClasses (in XSharp.VOSQLClasses.dll) Version: 2.21
Syntax
Copy
 VIRTUAL METHOD SetSelectiveRelation(
	oChild,
	uRelation,
	cRelation
) AS USUAL CLIPPER
Request Example View Source

Parameters

oChild (Optional)
Type: Usual
The server attached to the child server must be specified as a SQLTable object. If oSQLChild is omitted, all relations for this server are removed (the recommended way of doing this is the ClearRelations() method).
uRelation (Optional)
Type: Usual
The field name from this server. An alias can be used for the field name. (See the SQLSelect:FieldInfo() method to set an alias name).
cRelation (Optional)
Type: Usual
The array of field names representing the relation for the server. The array can also contain complex relational operators (SQL_RELOP_AND, SQL_RELOP_OR, SQL_RELOP_NOT, SQL_RELOP_OPENP, SQL_RELOP_CLOSEP).

Return Value

Type: Usual
TRUE if successful; otherwise, FALSE.
Remarks
Sends a NotifyRecordChange message to the child server, if successful. This method is equivalent to the SetRelation() method.
Examples
The API can take these forms:
X#
Copy
1oSQLCustomer:SetSelectiveRelation(oSQLOrders,;
2{||_FIELD->CustNo},"CustNo")
3oSQLCustomer:SetSelectiveRelation(oSQLOrders, CustNo)
4oSQLCustomer:SetSelectiveRelation(oSQLOrders,;
5{#LastName,#Initial,#FirstName})
See Also