idea Definition Query SQL shouldn't autocomplete “when “ to “WHENEVER” in ArcGIS Pro Ideas

Definition Query SQL shouldn't autocomplete “when “ to “WHENEVER”

Bud — Fri, 24 Feb 2023 15:05:29 GMT

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.

Re: Definition Query SQL shouldn't autocomplete “when “ to “WHENEVER”

Bud — Fri, 24 Feb 2023 15:10:06 GMT

@KoryKramer

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"