new query layer with parameters

mikedav1 — Tue, 08 Jul 2025 14:17:54 GMT

Trying to create a query layer with paramter as explained in

https://pro.arcgis.com/en/pro-app/latest/help/mapping/layer-properties/define-parameters-in-a-query-layer.htm

However the sql verify fails due to the double collon :: needed for defining a parameter in arcpro

Error: Underlying DBMS error[[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near '::'.]

Re: new query layer with parameters

tiffanypuett8 — Wed, 11 Mar 2026 14:48:28 GMT

Agreed. Yes this resource guide is insufficient and lacking in background information on the proper use of :: since it is not a standard SQL query language. Therefore, I submitted feedback on the article. Here is the reply I received:

"I’m sorry that it wasn’t clear for you. You are correct, the “::” is not standard SQL notation. It is in fact an ArcGIS construct.

Range parameters are prefixed by the keyword ::r:. Learn more about range parameters in this section: https://pro.arcgis.com/en/pro-app/3.4/help/mapping/layer-properties/define-parameters-in-a-query-layer.htm#GUID-CDEF0CD3-6B41-4F8E-B053-E6045D153EDC

Discrete parameters work with numeric (integer or double), date, or string values and are prefixed by the keyword ::. See this section for information about discrete parameters and how they are used: https://pro.arcgis.com/en/pro-app/3.4/help/mapping/layer-properties/define-parameters-in-a-query-layer.htm#ESRI_SECTION1_DA513455E19946BBBC3053C6263054F3 "

Did they just call out the same documentation I was providing feedback that it was confusing and inadequate? So much for the help. Ugh.

topic new query layer with parameters in ArcGIS Pro Questions

new query layer with parameters

Re: new query layer with parameters