You are here: Using General SQL Parser > Select Statement > Select list
ContentsIndexHome
PreviousUpNext
Select list

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

  • lftColumn: it represents a column information in create table statement. and following properties are valid only FieldType is lftColumn
    1. ColumnName
    2. ComputedColumnExpr
    3. FieldDataType
    4. ColumnConstraints
  • lftAttr, check FieldAttr for field information
  • lftExpression, field is an expression, check FieldExpr for detailed information.
  • lftSubquery, field is a subquery, check subquery for more.
 

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:

  1. tablefieldrel

Gudu software http://www.sqlparser.com
Send comments about this topic.