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