You are here: Symbol Reference > Classes > Common SQL Statement Classes > TCustomSqlStatement Class > public
ContentsIndexHome
PreviousUpNext
public

The public members of the TCustomSqlStatement class are listed here.

Events
Event 
Description 

Fired when bind variable was found during parsing sql.
This bind variable also stored in Params

Fired when sql variable was found during parsing sql.
This sql variable also stored in SqlVars property. 
Fields
Field 
Description 
cte 

Common table expression of this statement, usually used in select, delete, insert, update statement. 

Point to the corresponding original parse tree node of this class. 

Is this statement successfully parsed by the parser. This property is used internally. 

Check whether statement is ended with a semicolon or not; SemiColonEnded points to the actually source token if this property is true. 

SemiColonEnded points to the actually source token if statement is ended with semicolon. 

Source tokens consist of this sql statement. 

Type of sqlstatements. 

Table involved in sql statement. Meanings of this property maybe varied in different sql statement. 
Methods
Method 
Description 

Add a sourcetoken into SourceTokenList. Used internally. 

Help function.
After rebuild sql of this statement, check is it the same as original one. 

Check the syntax of this statement. 

Copy error message from Src to this sqltatement.
It is used internally to copy error message from parser to this sqlstatement if any. 

Create an instance of this class. Used to create
various sql statement objects. 

Help function to get fields information from an expression. Result is stored in pStrlist. 

Return original sql text without semicolon. 

Return original sql text without comments. 

Return sql text by iterating parse tree of this sqlstatement. Usually it should be the same as original sql text if parse tree is not modified manually. 

Find database objects in this sqlstatements.All
found database objects were stored in InspectedDBObjs

Iterate the parse tree of this statement. 

Parse this statement.

If there is no syntax error in this statement, more information will be collected from original parse tree. 

This event handle is assigned to parser's OnParseErrorHandle event to collect error message while checking syntax of this statement. 

Used to rebuild sql text if you remove sql variable in this statement. 
Properties
Property 
Description 

Database tokens in sql.
Meanings of following properties in TSourceToken Class when this token is a database token.

ParentToken, server source token.
ChildToken is null,
RelatedToken is null,
RelatedSubquery is null,
RelatedTokens, schema tokens of this database if TSourceToken.DBObjType is TDBObjType.ttobjSchema

Error number if there are syntax errors in this sql statement. 

Error message if there are syntax errors in this sql statement. 
Field list of this statement. Meanings of this property maybe varied in different sql statement. 

First token of this statement. 
Function tokens in sql. 
Index tokens in sql. 

Database objects inside this sql statement.
Before fetch info from this properties, execute
InspectDBObject first. 

Last token of this sql statement. 
Package tokens in sql.(Oracle only) 

Stores bind variable (:bindvar) in this statement. 

Original sql text of this statement. 
Root 

Corresponding raw parse tree node of this statement. 

Schema tokens in sql.
Meanings of following properties in TSourceToken Class when this token is a schema token.

ParentToken, database source token.
ChildToken is null,
RelatedToken is null,
RelatedSubquery is null,
RelatedTokens, table, function or other object tokens of this schema. 
Sequence tokens in sql. 

Server tokens in sql.
Meanings of following properties in TSourceToken Class when this token is a server token.

ParentToken is null,
ChildToken is null,
RelatedToken is null,
RelatedSubquery is null,
RelatedTokens, database tokens of this server if TSourceToken.DBObjType is TDBObjType.ttobjDatabase

Please use AsText property instead. 

Stores variable( @varname ) in this statement. 

Detail error information if there are syntax errors in this sql statement. 

Table list in this sql statement. Meanings of this property maybe varied in different sql statement. 

Table tokens in this sql.

Before go further details about this property, let's take a look at this sql,
 
Trigger tokens in this sql. 
View tokens in this sql. 

Where clause of this statement if any. 

Formatted sql text of WhereClause

Plain text of WhereClause
Gudu software http://www.sqlparser.com
Send comments about this topic.