Property Reference > Quick Reference for All Properties > UseFieldAliasInGroupBy Property |
C1Query.SQLInfo.UseFieldAliasInGroupBy= boolean
Notes
Read/Write at run time. Unavailable at design time. Property applies to SQLInfo object.
Description
Specifies whether the SQL dialect supported by the target database allows using aliases in GROUP BY instead of full expressions, as in
SELECT …, A + B AS S,… FROM … GROUP BY S
If this property is set to True, a calculated field (expression) can be represented in GROUP BY by its alias.
If this property is set to False, the full expression must be used in GROUP BY.
See Also