Property Reference > Quick Reference for All Properties > AllowExpressionInGroupBy Property |
C1Query.SQLInfo.AllowExpressionInGroupBy= 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 calculated fields (expressions) in GROUP BY, as in
SELECT …, A + B,… FROM … GROUP BY A + B
See Also