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 can modify FieldName to change field.
aliasclause which is type TLz_AliasClause can be used to get or set alias information of field. if there is no aliasclause, and you need to add an alias to field, you have to create a new instance of TLz_AliasClause, and then set aliasclause.AsText to any valid string.
You can check following demos shipped together with this component to find out more information about how to work with fields in select list:
Gudu software http://www.sqlparser.com
|
Send comments about this topic.
|