I can't use SQL in my ArcGIS pro

1012
13
06-24-2019 02:43 AM
Highlighted
New Contributor III

Can anyone help me?  way I can't use SQL in my ArcGIS pro, they always show me this message

Reply
0 Kudos
13 Replies
Highlighted
MVP Esteemed Contributor

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

https://pro.arcgis.com/en/pro-app/tool-reference/data-management/calculate-field.htm

Highlighted
New Contributor III

I tray with all types of data but still das not work...

Reply
0 Kudos
Highlighted
MVP Esteemed Contributor

did you try Python 3, and check the expression with the check mark

Highlighted
New Contributor II

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.

Cheers

Dave

Highlighted
MVP Regular Contributor

Using a Shapefile, should throw an error as below:

Highlighted
New Contributor II

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.

Dave

Highlighted
Esri Notable Contributor

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.

See https://pro.arcgis.com/en/pro-app/help/data/excel/work-with-excel-in-arcgis-pro.htm#ESRI_SECTION1_CF...

You could copy the table to a feature class in a geodatabase and then do the calculations you need.

Highlighted
MVP Esteemed Contributor

Try Python 3

Highlighted
New Contributor III

in ArcGIS pro, the SQL support just only enterprise GDB