Property Reference > Quick Reference for All Properties > UseFieldAliasInOrderBy Property |
C1Query.SQLInfo.UseFieldAliasInOrderBy= 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 ORDER BY instead of full expressions, as in
SELECT …, A + B AS S,… FROM … ORDER BY S
If this property is set to True, a calculated field (expression) can be represented in ORDER BY by its alias.
If this property is set to False, the full expression or index (see UseIndexInOrderBy property) must be used in ORDER BY.
See Also