Using the C1Query Control to Generate SQL > SQL Syntax Properties > Database Limitations on SQL |
True, if the database allows calculated fields (expressions) in GROUP BY. |
|
If True, a calculated field (expression) can be represented in ORDER BY by its alias, otherwise, the full expression must be used in ORDER BY (or integer index, see UseIndexInOrderBy). |
|
If True, a calculated field (expression) can be represented in GROUP BY by its alias, otherwise, the full expression must be used in GROUP BY. |
|
If True, a calculated field (expression) can be represented in WHERE by its alias, otherwise, the full expression must be used in WHERE. |
|
If True, the field’s integer index (its ordinal position in SELECT) is used in ORDER BY, instead of the field’s name. |
|
If True (default), C1Query creates an alias for fields with aggregation. Example: alias Sum_of_Price for SUM(Price). You may have to set this property to False, if your database does not allow aliases for aggregated fields. |
|
Determines maximum identifier length allowed in the database. |