Select statement includes following topics, any un-documented clauses in select statement will be added later.
Topic |
Description |
From clause in select statement was represented by JoinTables which is type of TLzJoinList. For more detailed information about join table in from clause, you can check "how to use join table". JoinTables represents from clause in a hierarchy structure which includes all information in from clause such as join table, join type and join condition, if you only need to fetch table information in from clause, you can use tables instead which is type of TLzTableList. Here are some key properties of TLzTable:
| |
Select list in select statement was represented by Fields which is type of TLzFieldList. You can use SelectClauseText to fetch or set whole string value of select list, or iterate Fields to handle each field separately. Here are some key properties of TLzField: FieldType which is type of TLzFieldType
You... more | |
Where clause in select statement was represented by 2 properties:
You can check following demos shipped together with this component to find out more information about how to work with expression
| |
Group by clause in select statement was represented by 2 properties:
Text in GroupbyClauseText includes group by keyword, so if you fetch value from GroupbyClauseText, you can see something like this: group by f1,f2, but not value like this: f1,f2. If you want to append new field value, then do something like this: GroupbyClauseText = GroupbyClauseText + ",f3" Or set new value of GroupbyClauseText, GroupbyClauseText = "group by f3";
| |
Having clause in select statement was represented by 2 properties:
You can check following demos shipped together with this component to find out more information about how to work with expression
| |
Order by clause in select statement was represented by 2 properties:
there are 2 kinds of field that can be represents by TLzOrderBy, use SortItemType which is type of TLzSortItemType to determine type of field.
|
Gudu software http://www.sqlparser.com
|
Send comments about this topic.
|