I can't use SQL in my ArcGIS pro

[AliAzzouhri1]

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

[KoryKramer]

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]

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.

[JoshuaBixby]

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

[HilaryCampbell]

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

[Rajeshmadhaiyan]

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