Class TCaseExpression

Namespace

gudusoft.gsqlparser.nodes

Assembly

gudusoft.gsqlparser.dll

CASE expressions let you use IF ... THEN ... ELSE logic in SQL statements without having to invoke procedures.

simple case expression:

• CASE input_expr {WHEN comparison_expr THEN return_expr}[...n] [ELSE else_expr] END

• input_expr: Input_expr
• WHEN...THEN... list: WhenClauseItemList
• else_expr: Else_expr

searched case expression:

• CASE {WHEN comparison_expr THEN return_expr}[...n] [ELSE else_expr] END
  • WHEN...THEN... list: WhenClauseItemList
  • else_expr: Else_expr

plsql case statement

• CASE input_expr {WHEN comparison_expr THEN statement}[...n] [ELSE else_statement_list] END
  • input_expr: Input_expr
  • WHEN...THEN... list: WhenClauseItemList
  • else_statement_list: Else_statement_list

public class TCaseExpression : TParseTreeNode, Visitable

Inheritance

object

TParseTreeNode

TCaseExpression

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)

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

Else_expr

public virtual TExpression Else_expr { get; set; }

Property Value

TExpression

Else_statement_list

public virtual TStatementList Else_statement_list { get; set; }

Property Value

TStatementList

else statement list in plsql case statement.

Else_statement_node_list

public virtual TStatementListSqlNode Else_statement_node_list { get; set; }

Property Value

TStatementListSqlNode

Input_expr

public virtual TExpression Input_expr { get; set; }

Property Value

TExpression

WhenClauseItemList

List of When...Then... clause.

public virtual TWhenClauseItemList WhenClauseItemList { get; set; }

Property Value

TWhenClauseItemList

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, object)

public override void init(object arg1, object arg2, object arg3)

Parameters

arg1 object

arg2 object

arg3 object