Select to view content in your preferred language

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

552
1
11-19-2022 04:30 PM
Status: Open
Labels (1)
Bud
by
Honored Contributor

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 ".

Bud_0-1668904131798.png

It autocompleted  "when "  to  "WHENEVER".

Bud_0-1668904298668.png

That's not what I wanted. It changed valid SQL to invalid SQL.

 ArcGIS Pro 2.6.8.

 

Related: Optionally disable SQL expression autocomplete

1 Comment
Bud
by

@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"