topic Re: 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, in ArcGIS Pro Questions

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,

JamalNUMAN — Wed, 10 May 2023 08:18:25 GMT

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?

Re: 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,

BarryNorthey — Wed, 10 May 2023 15:13:01 GMT

Try wrapping %school% in single quotes '%school%' not double quotes "%school%".

Re: 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,

JamalNUMAN — Sat, 13 May 2023 20:15:55 GMT

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?

Re: 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,

BarryNorthey — Sat, 13 May 2023 21:35:50 GMT

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

Re: 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,

JamalNUMAN — Sat, 20 May 2023 17:26:17 GMT

What’s meant by “clause mode”? how the script is recognized as “clause mode”?

Re: 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,

BarryNorthey — Sat, 20 May 2023 18:10:45 GMT

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 mode to on. This is the actual SQL expression that Pro uses. You can also toggle SQL off and return to Clause mode.

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

Re: 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,

PaulMason — Wed, 25 Sep 2024 22:04:10 GMT

I am also looking for an answer to this problem. It is a mode issue (as mentioned in the error message). So I just want to know how to restore the usual "Where..." mode so that I can select the Field, Operator, and enter a value. It would also be nice to know why this "clause" mode became active without me explicitly setting it?

Re: 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,

PaulMason — Wed, 25 Sep 2024 22:09:51 GMT

...excuse me, it IS in clause mode but it beats me why the SQL button is jammed and cannot be toggled. I guess the "Where" (with arguments) will appear when SQL is Off.

Re: 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,

ElenaFavaro — Fri, 24 Jan 2025 08:52:50 GMT

I found this bug report that might be helpful: https://support.esri.com/en-us/bug/the-warning-the-expression-cant-be-edited-in-clause-mod-bug-000113319

I was also stuck in "clause mode". I deleted the predefiend expression in the comment box, and then was able to toggle SQL off.