Select to view content in your preferred language

I can't use SQL in my ArcGIS pro

5344
16
06-24-2019 02:43 AM
AliAzzouhri1
Regular Contributor

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

0 Kudos
16 Replies
KoryKramer
Esri Community Moderator

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

HilaryCampbell
Regular Contributor

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.

0 Kudos
JoshuaBixby
MVP Esteemed Contributor

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

0 Kudos
HilaryCampbell
Regular Contributor

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

0 Kudos
Rajeshmadhaiyan
Occasional Contributor

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

Rajeshmadhaiyan_0-1676610816740.png

Thanks,

Rajesh M

remoterajesh@gmail.com

 

0 Kudos
Rajeshmadhaiyan
Occasional Contributor

Hello, JesseCloutier

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

mentioned below the annotation table.

Rajeshmadhaiyan_0-1742636886475.png

Need Output: annotation please check attached below screenshot

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

 361: 24

Rajeshmadhaiyan_1-1742637079425.png

Thanks,

Rajesh M

0 Kudos
Rajeshmadhaiyan
Occasional Contributor

Hi Team,

Hello, JesseCloutier

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

mentioned below the annotation table.

Rajeshmadhaiyan_0-1742636886475.png

Need Output: annotation please check attached below screenshot

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

 361: 24

Rajeshmadhaiyan_1-1742637079425.png

Thanks,

Rajesh M

Tags (1)
0 Kudos