https://community.esri.com/t5/arcgis-pro-sdk-ideas/new-method-bool-isvaliddefinitionquery-string-sql/idi-p/1537681 <P>I'd like to have a new method for BasicFeatureLayer and SubtypeGroupLayer:&nbsp;bool IsValidDefinitionQuery(string sql).</P><P>If the user is in charge of the content of the definition query, it could have syntax errors or fields that are missing from the layer. So I'd like to validate the sqlbefore I set it as definition query. Currently the workaround is to perform a Search on the layer using the sql as the WhereClause and checking for a GeodatabaseException with HResult == -2146233088. This is ugly and clumsy. Also, in my add-in the user's definition query is to be applied to every layer for which it is valid, and given that there are hundreds of layers, this workaround makes it prohibitively slow.</P> Thu, 12 Sep 2024 10:26:37 GMT PeterVanSchevensteen 2024-09-12T10:26:37Z https://community.esri.com/t5/arcgis-pro-sdk-ideas/new-method-bool-isvaliddefinitionquery-string-sql/idi-p/1537681 <P>I'd like to have a new method for BasicFeatureLayer and SubtypeGroupLayer:&nbsp;bool IsValidDefinitionQuery(string sql).</P><P>If the user is in charge of the content of the definition query, it could have syntax errors or fields that are missing from the layer. So I'd like to validate the sqlbefore I set it as definition query. Currently the workaround is to perform a Search on the layer using the sql as the WhereClause and checking for a GeodatabaseException with HResult == -2146233088. This is ugly and clumsy. Also, in my add-in the user's definition query is to be applied to every layer for which it is valid, and given that there are hundreds of layers, this workaround makes it prohibitively slow.</P> Thu, 12 Sep 2024 10:26:37 GMT https://community.esri.com/t5/arcgis-pro-sdk-ideas/new-method-bool-isvaliddefinitionquery-string-sql/idi-p/1537681 PeterVanSchevensteen 2024-09-12T10:26:37Z