ArcGIS Pro 3.0.2: The “select by attributes” tool has “the expression can’t be edited in clause mode” issue when working with SQL option,
ArcGIS Pro 3.0.2: The “select by attributes” tool has “the expression can’t be edited in clause mode” issue when working with SQL option,
As per the screenshot below, I couldn’t figure out why the “select by attributes” tool has “the expression can’t be edited in clause mode” issue when working with SQL option,
What might be the problem here?
With same syntax, the obtained error message now makes sense as per the screenshot below. Why was the Pro giving the “the expression can’t be edited in clause mode” error that doesn't make any sense?
When I built a selection query in clause mode it wrapped the target info I was looking for in single quotations, not double quotes and it turns red when displayed in SQL mode. In my example I am selecting anyone with initials J (text) in field INITIALS:
When I replace single quotes with double quotes in SQL mode and then try to return to clause mode I get the message you are getting and the entry in double quotes appears as black text.
I assume the warning “the expression can’t be edited in clause mode” is letting you know that you can't switch from SQL mode to clause mode as it doesn't recognize the syntax used (double quotes).
Selection queries can be built in Clause mode or directly in SQL mode as explained here: https://pro.arcgis.com/en/pro-app/latest/help/analysis/geoprocessing/basics/query-builder.htm
Queries built in Clause mode (interactive helper primarily for those that don't know how to structure a SQL query). It can be viewed in SQL mode by toggling 
You can also go directly to SQL mode directly and build your query but it is possible that the syntax you used is not recognized by Clause mode or there is an error that prevents opening clause mode, such as double quotes vs single quotes. (don't know).
