Can anyone help me? way I can't use SQL in my ArcGIS pro, they always show me this message
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
I need one help from you. Regarding Tags label annotation:
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
remoterajesh@gmail.com
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.
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
in ArcGIS pro, the SQL support just only enterprise GDB
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
Try Python 3
did you try Python 3, and check the expression with the check mark
I tray with all types of data but still das not work...
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.
Using a Shapefile, should throw an error as below:
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
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
Membros conectados podem postar, seguir atualizações e mais. Novo aqui? Registre uma conta gratuita.
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.
