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

Namespace: Spotfire.Dxp.Data
Assembly: Spotfire.Dxp.Data (in Spotfire.Dxp.Data.dll) Version: 30.0.11525.4184 (30.0.11525.4184)
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.9, 7.8, 7.7, 7.6, 7.5, 7.12, 7.11, 7.10, 7.0
See Also

Reference

DataRelationCollection Class
Spotfire.Dxp.Data Namespace