Property Reference > Quick Reference for All Properties > CreateAliasForAggregatedField Property |
C1Query.SQLInfo.CreateAliasForAggregatedField= boolean
Notes
Read/Write at run time. Unavailable at design time. Property applies to SQLInfo object.
Description
If this property is set to True (default), C1Query creates an alias for fields with aggregation. For example: alias Sum_of_Price for SUM(Price). This is the normal behavior and you may need to override it only for databases that don’t support aliases for aggregated fields. In this case, to avoid syntax errors on SQL execution, set this property to False.
See Also