A Join object contains the properties for a relation in the data dictionary. This object has no methods.
All properties are read-write.
|ChildExpression||String||The aliased field name of the child field for the join. This is used for simple expressions and is empty if JoinExpression is filled in.|
|ChildTable||String||The name of the child table in the relationship.|
|JoinExpression||String||The join expression for the relation. This is used for complex expressions and is empty if ChildExpression and ParentExpression are filled in.|
|JoinName||String||The name of the join. In Stonefield Query, the name is usually the parent table name and the child table name separated by a comma (that is, PARENT,CHILD).|
|JoinType||Numeric||The join type:
|ParentExpression||String||The aliased field name of the parent field for the join. This is used for simple expressions and is empty if JoinExpression is filled in.|
|ParentTable||String||The name of the parent table in the relationship.|
|Version||String||The version number for the relation.|
|Weight||Numeric||The weighting for the join.|
See alsoJoins Collection | Relation Properties
© Stonefield Software Inc., 1996-2019 • Updated: 12/21/18
Comment or report problem with topic