topic Re: I can't use SQL in my ArcGIS pro in ArcGIS Pro Questions

I can't use SQL in my ArcGIS pro

AliAzzouhri1 — Mon, 24 Jun 2019 09:43:02 GMT

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

Re: I can't use SQL in my ArcGIS pro

DanPatterson_Retired — Mon, 24 Jun 2019 10:00:41 GMT

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

Re: I can't use SQL in my ArcGIS pro

DaveBarrett2 — Mon, 24 Jun 2019 10:03:55 GMT

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

Re: I can't use SQL in my ArcGIS pro

Asrujit_SenGupta — Mon, 24 Jun 2019 10:15:26 GMT

Using a Shapefile, should throw an error as below:

Re: I can't use SQL in my ArcGIS pro

KoryKramer — Mon, 24 Jun 2019 12:33:37 GMT

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_CFEF9994188849D89C6F74552D58C271

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

Re: I can't use SQL in my ArcGIS pro

AliAzzouhri1 — Mon, 24 Jun 2019 12:45:41 GMT

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

Re: I can't use SQL in my ArcGIS pro

DanPatterson_Retired — Mon, 24 Jun 2019 13:09:53 GMT

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

Re: I can't use SQL in my ArcGIS pro

DanPatterson_Retired — Mon, 24 Jun 2019 13:11:06 GMT

Try Python 3

Re: I can't use SQL in my ArcGIS pro

DaveBarrett2 — Tue, 25 Jun 2019 11:16:16 GMT

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

Re: I can't use SQL in my ArcGIS pro

AliAzzouhri1 — Tue, 25 Jun 2019 12:02:57 GMT

in ArcGIS pro, the SQL support just only enterprise GDB

Re: I can't use SQL in my ArcGIS pro

KoryKramer — Tue, 25 Jun 2019 13:21:45 GMT

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

Re: I can't use SQL in my ArcGIS pro

HilaryCampbell — Mon, 08 Jun 2020 14:26:47 GMT

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.

Re: I can't use SQL in my ArcGIS pro

JoshuaBixby — Mon, 08 Jun 2020 14:57:22 GMT

Hilary, what SQL functionality has been removed from either earlier versions of Pro or from ArcGIS Desktop/ArcMap?

Re: I can't use SQL in my ArcGIS pro

HilaryCampbell — Mon, 08 Jun 2020 17:23:12 GMT

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

Re: I can't use SQL in my ArcGIS pro

Rajeshmadhaiyan — Fri, 17 Feb 2023 05:16:07 GMT

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

I have using annotation feature class layer in ArcGIS Map now i am migration to ArcGIS pro for Existing Sql "[TextStringEdit] &vbnewline & [Post]" not working ArcIGS pro field calculator but it's showing python 3 and Arcade only not showing SQL.

I am getting errors below

Thanks,

Rajesh M

remoterajesh@gmail.com

Re: I can't use SQL in my ArcGIS pro

Rajeshmadhaiyan — Sat, 22 Mar 2025 09:59:57 GMT

Hello, JesseCloutier

I need one help from you. Regarding Tags label annotation:

mentioned below the annotation table.

Need Output: annotation please check attached below screenshot

NH-C20-380 (10/15/2024)

361: 24

Thanks,

Rajesh M

Re: I can't use SQL in my ArcGIS pro

Rajeshmadhaiyan — Sat, 22 Mar 2025 10:01:40 GMT

Hi Team,

Hello, JesseCloutier

I need one help from you. Regarding Text Tags label annotation:

mentioned below the annotation table.

Need Output: annotation please check attached below screenshot

NH-C20-380 (10/15/2024)

361: 24

Thanks,

Rajesh M