laptop and a wrench

Bug

Running Calculate Field while using SQL returns the error message, "Error 160327: A column was specified that does not exist", which does not point out that the syntax is incorrect.

Last Published: September 22, 2021 ArcGIS Pro
Bug ID Number BUG-000139553
SubmittedApril 30, 2021
Last ModifiedMay 9, 2025
Applies toArcGIS Pro
Version found2.7.3
Operating SystemWindows OS
Operating System Version10.0 64 Bit
StatusWill Not Be Addressed

Additional Information

Double quotes are unable to be used to indicate a string, it is incorrect syntax. The warning return is not ideal but is returned by the underlying database when assessing the expression. Further examination of the expression value in the client code resulted in performance loss, which is not acceptable when the point of supporting SQL expressions is for fast calculation.

Steps to Reproduce

Bug ID: BUG-000139553

Software:

  • ArcGIS Pro

Get notified when the status of a bug changes

Download the Esri Support App

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options