idea Single-line SQL comments in definition queries in ArcGIS Pro Ideas https://community.esri.com/t5/arcgis-pro-ideas/single-line-sql-comments-in-definition-queries/idi-p/1579783 <P>For use cases like&nbsp;<a href="https://community.esri.com/t5/user/viewprofilepage/user-id/458875">@AlfredBaldenweck</a>&nbsp;’s idea “<SPAN>Definition Query: Let me add an overarching clause with togglable secondary clauses”&nbsp;<A href="https://community.esri.com/t5/arcgis-pro-ideas/definition-query-let-me-add-an-overarching-clause/idi-p/1579545/highlight/true" target="_blank" rel="noopener">https://community.esri.com/t5/arcgis-pro-ideas/definition-query-let-me-add-an-overarching-clause/idi-p/1579545/highlight/true</A></SPAN><SPAN>:&nbsp;</SPAN></P><P><SPAN>It would help to temporarily comment-out lines of SQL in definition queries using the -- SQL syntax. My experience is that syntax is not well-supported by Pro, and not for all geodatabase types. In some cases the multi-line comment syntax works: /*…. But that’s not a best practice when commenting out a single line.</SPAN></P> Fri, 31 Jan 2025 20:08:59 GMT Bud 2025-01-31T20:08:59Z Single-line SQL comments in definition queries https://community.esri.com/t5/arcgis-pro-ideas/single-line-sql-comments-in-definition-queries/idi-p/1579783 <P>For use cases like&nbsp;<a href="https://community.esri.com/t5/user/viewprofilepage/user-id/458875">@AlfredBaldenweck</a>&nbsp;’s idea “<SPAN>Definition Query: Let me add an overarching clause with togglable secondary clauses”&nbsp;<A href="https://community.esri.com/t5/arcgis-pro-ideas/definition-query-let-me-add-an-overarching-clause/idi-p/1579545/highlight/true" target="_blank" rel="noopener">https://community.esri.com/t5/arcgis-pro-ideas/definition-query-let-me-add-an-overarching-clause/idi-p/1579545/highlight/true</A></SPAN><SPAN>:&nbsp;</SPAN></P><P><SPAN>It would help to temporarily comment-out lines of SQL in definition queries using the -- SQL syntax. My experience is that syntax is not well-supported by Pro, and not for all geodatabase types. In some cases the multi-line comment syntax works: /*…. But that’s not a best practice when commenting out a single line.</SPAN></P> Fri, 31 Jan 2025 20:08:59 GMT https://community.esri.com/t5/arcgis-pro-ideas/single-line-sql-comments-in-definition-queries/idi-p/1579783 Bud 2025-01-31T20:08:59Z