DataRelationCollectionAdd Method TIBCO Spotfire 7.6 API Reference
Adds a relation to this collection.

Namespace: Spotfire.Dxp.Data
Assembly: Spotfire.Dxp.Data (in Spotfire.Dxp.Data.dll) Version: 25.11.10401.3615 (25.11.10401.3615)
Syntax
C#
Copy
public DataRelation Add(
	DataTable leftTable,
	DataTable rightTable,
	string relationExpression
)

Parameters

leftTable
Type: Spotfire.Dxp.DataDataTable
The left table.
rightTable
Type: Spotfire.Dxp.DataDataTable
The right table.
relationExpression
Type: SystemString
The relation expression.

Return Value

Type: DataRelation
The new data relation.
Exceptions
ExceptionCondition
ArgumentExceptionThrown 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.
Version Information

Supported in: 7.6, 7.5, 7.0, 6.5, 6.0, 5.5, 5.0
See Also

Reference

DataRelationCollection Class
Spotfire.Dxp.Data Namespace