Table of Contents

Class TCursorDeclStmt

Namespace
gudusoft.gsqlparser.stmt
Assembly
gudusoft.gsqlparser.dll

Represents cursor related statement, including:

Cursor declaration

Cursor specification

Cursor body

Ref cursor type definition 

public class TCursorDeclStmt : TCustomSqlStatement, Visitable
Inheritance
TCursorDeclStmt
Implements
Inherited Members

Constructors

TCursorDeclStmt() 

public TCursorDeclStmt()

TCursorDeclStmt(EDbVendor) 

public TCursorDeclStmt(EDbVendor dbvendor)

Parameters

dbvendor EDbVendor

Fields

kind_cursor_body 

public const int kind_cursor_body = 3

Field Value

int

kind_cursor_declaration 

public const int kind_cursor_declaration = 1

Field Value

int

kind_cursor_specification 

public const int kind_cursor_specification = 2

Field Value

int

kind_ref_cursor_type_definition 

public const int kind_ref_cursor_type_definition = 4

Field Value

int

Properties

CursorName 

public virtual TObjectName CursorName { get; set; }

Property Value

TObjectName

CursorParameterDeclarations

List of cursor parameter declaration, which is represented by TParameterDeclaration. @return

public virtual TParameterDeclarationList CursorParameterDeclarations { get; set; }

Property Value

TParameterDeclarationList

CursorTypeName 

public virtual TObjectName CursorTypeName { get; set; }

Property Value

TObjectName

Kind 

public virtual int Kind { get; set; }

Property Value

int

Rowtype 

public virtual TTypeName Rowtype { get; set; }

Property Value

TTypeName

Subquery

A SQL SELECT statement. If the cursor declaration declares parameters, each parameter must appear in select_statement. @return

public virtual TSelectSqlStatement Subquery { get; set; }

Property Value

TSelectSqlStatement

Methods

accept(TParseTreeVisitor) 

public override void accept(TParseTreeVisitor v)

Parameters

v TParseTreeVisitor

acceptChildren(TParseTreeVisitor) 

public override void acceptChildren(TParseTreeVisitor v)

Parameters

v TParseTreeVisitor

doParseStatement(TCustomSqlStatement)

analyze SQL

public override int doParseStatement(TCustomSqlStatement psql)

Parameters

psql TCustomSqlStatement

Returns

int

init(object)

Initialize a query tree node.

public override void init(object arg1)

Parameters

arg1 object

setCursorName(TObjectName) 

public void setCursorName(TObjectName o)

Parameters

o TObjectName

setCursorParameterDeclarations(TParameterDeclarationList) 

public void setCursorParameterDeclarations(TParameterDeclarationList l)

Parameters

l TParameterDeclarationList

setKind(int) 

public void setKind(int i)

Parameters

i int
Edit this page