Inline Variable Substitution in SQL Expression Variable Using Model Parameter Value ArcGIS PRO

Gene_Sipes — Fri, 07 Oct 2022 15:41:01 GMT

I am trying to port over a model that I built in ArcMap, to Pro.

I am receiving a SQL error stating "fields do not match" when trying to set up a SQL Expression for use in the Select Layer By Attributes tool. The SQL Expression is connected to the Select by Attributes Tool, and attempts to use inline variable substitution to insert the model parameter value "SectorNumber" in the expression. The goal is to create a selection set of records from Centerline202.. that match Sector = %SectorNumber%.

Here is an overview of the model layout.

Here is a screenshot showing a valid SQL message when using a hardcoded value of 3.

When trying to add the "SectorNumber" model parameter as an inline variable in the SQl Expression I get:

I have tried numerous versions of %SectorNumber%, "%SectorNumber%", (%SectorNumber%), and cannot get anything to work.

The data is file based (FGDB)

Re: Inline Variable Substitution in SQL Expression Variable Using Model Parameter Value ArcGIS PRO

britthartery — Fri, 22 Nov 2024 16:44:18 GMT

I'm having the same problem. It worked when I made the fields text though, using just (for example) ID = %Value%

Re: Inline Variable Substitution in SQL Expression Variable Using Model Parameter Value ArcGIS PRO

Gene_Sipes — Mon, 25 Nov 2024 14:17:06 GMT

I never found a solution, and gave up a while back. Thanks for your input though!

topic Re: Inline Variable Substitution in SQL Expression Variable Using Model Parameter Value ArcGIS PRO in Geoprocessing Questions

Inline Variable Substitution in SQL Expression Variable Using Model Parameter Value ArcGIS PRO

Re: Inline Variable Substitution in SQL Expression Variable Using Model Parameter Value ArcGIS PRO

Re: Inline Variable Substitution in SQL Expression Variable Using Model Parameter Value ArcGIS PRO