In an SQL expression, when typing something like b.asset_id :
When typing the letter b , then typing a period . , the period triggers it to autocomplete the b to BETWEEN .
That's not what I wanted. I wanted to type b.asset_id , not BETWEEN.
Could that behavior be changed?
Thanks.
Here's an example of a working subquery (has a correlated subquery with a table alias: b ).
roadinsptable.objectid IN ( SELECT objectid FROM roadinsptable b WHERE b.asset_id = roadinsptable.asset_id ORDER BY date_ DESC, condition DESC LIMIT 1 )
Source: One-to-first joins: Control what related record is used
Data:
Video of me trying to write b.asset_id, but it auto-completes b. to BEFORE or BETWEEN (depending on the scenario), which isn't what I want.
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.