DataRelationCollection.Add Method

DataRelationCollection Add Method

TIBCO Spotfire 6.0 API Reference

Adds a relation to this collection.

Namespace: Spotfire.Dxp.Data
Assembly: Spotfire.Dxp.Data (in Spotfire.Dxp.Data.dll) Version: 13.19.7018.3940 (13.19.7018.3940)

Syntax

C++

Copy to Clipboard Print

public DataRelation Add(
	DataTable leftTable,
	DataTable rightTable,
	string relationExpression
)

public DataRelation Add(
	DataTable leftTable,
	DataTable rightTable,
	string relationExpression
)

Parameters

leftTable: Type: Spotfire.Dxp.Data DataTable
The left table.

rightTable: Type: Spotfire.Dxp.Data DataTable
The right table.

relationExpression: Type: System String
The relation expression.

Return Value

Type: DataRelation
The new data relation.

Exceptions

Exception	Condition
System ArgumentException	Thrown if the relation is not valid.

Remarks

If the expression is F=H and one of the subexpressions, say H, has return type string while the other do not this operation will rewrite the expression so H is casted to F:s datatype. This differs from how other expressions work in dxp as string is not normally implicitly casted to other datatypes but is needed for API-compatibility here.