Class TCTE

Namespace

gudusoft.gsqlparser.nodes

Assembly

gudusoft.gsqlparser.dll

A common table expression permits defining a result table with a table-name that can be specified as a table name in any FROM clause of the fullselect that follows.

Multiple common table expressions can be specified following the single WITH keyword.

Each common table expression specified can also be referenced by name in the FROM clause of subsequent common table expressions.

Syntax:

table-name [column-name [,...n]] AS (fullselect)

public class TCTE : TParseTreeNode, Visitable

Inheritance

object

TParseTreeNode

TCTE

Implements

Visitable

Inherited Members

TParseTreeNode.dbvendor

TParseTreeNode.IsIncludingOriginalTokens()

TParseTreeNode.setChanged()

TParseTreeNode.IsUnderlyingTokenChanged()

TParseTreeNode.Gsqlparser

TParseTreeNode.IncludingComment

TParseTreeNode.DummyTag

TParseTreeNode.startToken

TParseTreeNode.getStartToken()

TParseTreeNode.getEndToken()

TParseTreeNode.endToken

TParseTreeNode.ColumnNo

TParseTreeNode.LineNo

TParseTreeNode.NodeType

TParseTreeNode.init(object)

TParseTreeNode.init(object, object, object)

TParseTreeNode.init(object, object, object, object)

TParseTreeNode.init(object, object, object, object, object)

TParseTreeNode.init(object, object, object, object, object, object)

TParseTreeNode.setStartToken(TSourceToken)

TParseTreeNode.setStartToken(TParseTreeNode)

TParseTreeNode.setStartToken<T>(List<T>)

TParseTreeNode.setEndToken(TSourceToken)

TParseTreeNode.setEndToken(TParseTreeNode)

TParseTreeNode.setEndToken<T>(List<T>)

TParseTreeNode._stringValue

TParseTreeNode.String

TParseTreeNode.SourceTokenList

TParseTreeNode.ToString(bool)

TParseTreeNode.ToString()

TParseTreeNode.ToScript()

TParseTreeNode.addAllMyTokensToTokenList(TSourceTokenList, int)

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

Properties

ColumnList

public virtual TObjectNameList ColumnList { get; set; }

Property Value

TObjectNameList

DeleteStmt

public virtual TDeleteSqlStatement DeleteStmt { get; set; }

Property Value

TDeleteSqlStatement

InsertStmt

public virtual TInsertSqlStatement InsertStmt { get; set; }

Property Value

TInsertSqlStatement

PreparableStmt

preparable statement can be:

Subquery

orUpdateStmt

orInsertStmt

orDeleteStmt @return

public virtual TCustomSqlStatement PreparableStmt { get; set; }

Property Value

TCustomSqlStatement

Subquery

fullselect of this common table expression. @return

public virtual TSelectSqlStatement Subquery { get; set; }

Property Value

TSelectSqlStatement

TableName

public virtual TObjectName TableName { get; set; }

Property Value

TObjectName

table name of this common table expression.

UpdateStmt

public virtual TUpdateSqlStatement UpdateStmt { get; set; }

Property Value

TUpdateSqlStatement

Methods

accept(TParseTreeVisitor)

public override void accept(TParseTreeVisitor v)

Parameters

v TParseTreeVisitor

acceptChildren(TParseTreeVisitor)

public override void acceptChildren(TParseTreeVisitor v)

Parameters

v TParseTreeVisitor

doParse(TCustomSqlStatement, ESqlClause)

analyze this node

public override void doParse(TCustomSqlStatement psql, ESqlClause plocation)

Parameters

psql TCustomSqlStatement

plocation ESqlClause

init(object, object)

public override void init(object arg1, object arg2)

Parameters

arg1 object

arg2 object

searchColumnInResultSet(TCustomSqlStatement, TTable, TObjectName, bool)

public virtual bool searchColumnInResultSet(TCustomSqlStatement pSql, TTable pTable, TObjectName pColumn, bool pMustIn)

Parameters

pSql TCustomSqlStatement

pTable TTable

pColumn TObjectName

pMustIn bool

Returns

bool

setColumnList(TObjectNameList)

public void setColumnList(TObjectNameList cl)

Parameters

cl TObjectNameList