Class Join

Contains the properties for a relation in the data dictionary.

Please note that any changes you make to this item will only be saved in Stonefield Query after you call the Dispose() method.

System.Object
  SFQWrapper.SQBase
    SFQWrapper.SQItem
      SFQWrapper.Join
public class Join : SQItem

Class Members

MemberDescription

ChildExpression

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

The name of the child table in the relationship.

ErrorMessage

The message for any error that occurred.

JoinExpression

The join expression for the relation.

This is used for complex expressions and is empty if ChildExpression and ParentExpression are filled in.

JoinName

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

The join type:

  • 0: inner join
  • 1: left outer join
  • 2: right outer join
  • 3: full join.

ParentExpression

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

The name of the parent table in the relationship.

Version

The version number for the relation.

Weight

The weighting for the join.

Requirements

Namespace: SFQWrapper
Assembly: sfqwrapper.dll

© Stonefield Software Inc., 2023 • Updated: 06/11/10
Comment or report problem with topic