Select to view content in your preferred language

Single-line SQL comments in definition queries

204
0
01-28-2025 03:34 PM
Status: Open
Labels (1)
Bud
by
Esteemed Contributor

For use cases like @AlfredBaldenweck ’s idea “Definition Query: Let me add an overarching clause with togglable secondary clauses” https://community.esri.com/t5/arcgis-pro-ideas/definition-query-let-me-add-an-overarching-clause/idi...

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.

Tags (1)