Can anyone help me? way I can't use SQL in my ArcGIS pro, they always show me this message
To calculate strings to text or character fields, on the dialog box, the string must use double quotation marks ("string"), or in scripting, the string using double quotation marks must also be encapsulated in single quotation marks ('"string"').
I tray with all types of data but still das not work...
did you try Python 3, and check the expression with the check mark
It looks like your features are in a shapefile?
SQL is not supported as an input method for Shapefiles, if you select the green tick a tthe bottom of your expression it should valiate it and warn that SQL is only supported for feature services.
Using a Shapefile, should throw an error as below:
Apologies, I was infering frm the FID field rathe tha OBJECTID, I an this alter on a Shapefile and go error above. I also got an error stating it needed to be a feature service t use SQL.
Why do we think this is a shapefile - did I miss something? I would guess that the input is an Excel table (field is Field 1) - ArcGIS cannot directly edit (i.e. calculate a field) Excel tables.
You could copy the table to a feature class in a geodatabase and then do the calculations you need.
Try Python 3
in ArcGIS pro, the SQL support just only enterprise GDB
Ah, yes. Should have caught that from the original question...
From the Calculate Field help: "SQL expressions were implemented to support faster calculations for feature services. Instead of performing calculations one feature or row at a time, a single request is set to the feature service, resulting in significantly faster calculations.
Only nonversioned feature services support SQL expressions. For other formats, use Python or Arcade expressions."
And now the error is referenced on the thread: https://pro.arcgis.com/en/pro-app/tool-reference/tool-errors-and-warnings/001001-010000/tool-errors-and-warnings-02526-02550-002536.htm
Hi, Kory. Thank you for the error reference. Question: will full SQL functionality be restored in ArcGIS Pro, or is it being deliberately phased out? I for one have built up a lot of expertise in SQL over the years.
Hilary, what SQL functionality has been removed from either earlier versions of Pro or from ArcGIS Desktop/ArcMap?
SQL cannot be used to filter versioned databases. From the error link above: "Currently, only feature services support SQL expressions. For other formats, use Python or Arcade expression types."
Retrieving data ...