In the Definition Query window in SQL mode:
When typing the word “when “, it autocompletes to “WHENEVER”.
I don't know what use case WHENEVER applies to, but 99.999% of the time we'd want WHEN, not WHENEVER.
Example:
I typed "field1 = case when ". Note the space at the end of "when ".
It autocompleted "when " to "WHENEVER".
That's not what I wanted. It changed valid SQL to invalid SQL.
ArcGIS Pro 2.6.8.
This idea can be closed as well. It sounds like this specific issue would not be addressed. But instead, we might be given the option to disable autocomplete in the future.
Esri Canada Case #03271348 - SQL Expression: Typing a period or space after a table alias autocompletes to BEFORE or BETWEEN keywords
"After discussing with some colleagues, we decided that an enhancement request is best suited for this:
ENH-000156091: Add the option to disable autocomplete when writing SQL queries in ArcGIS Pro"
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.