The relation object is a member of the data source object. It defines a relationship between two tables when the data source object contains a dynamic view.

The relation object is exposed through the IRelation interface.

Properties

definition

An SQL expression, which defines a relationship between two tables.

Read/Write property
Type: string

relation.definition = "Table1.ID=Table2.ID"

join

A join type for the relation object. The available values are: "INNER","LEFT", RIGHT", "FULL".  (See dynamic view for an explanation of what these values mean.)

Read/Write property
Type: string

relation.definition = "LEFT"