The public members of the TCustomSqlStatement class are listed here.
Field |
Description |
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. |
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. | |
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. |
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. | |
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.
|