topic IQueryFilterDefinition2 Bug? in ArcObjects SDK Questions https://community.esri.com/t5/arcobjects-sdk-questions/iqueryfilterdefinition2-bug/m-p/324785#M8474 <HTML><HEAD></HEAD><BODY><SPAN>I am running into an issue with the IQueryFilterDefinition2 interface.&nbsp; Here is what I am seeing.&nbsp; The PrefixClause works perfectly until I start an edit session.&nbsp; I can execute the query against a table, not a feature class, and get the value of DOCUMENTYPE from the row.&nbsp; Once I begin editing, the value of DOCUMENTYPE is null.&nbsp; I stop editing, run the query again, and it works.&nbsp; Additionally, the query is returning all of the records, so it is bacisally ignoring the DISTINCT prefic clause.</SPAN><BR /><BR /><SPAN>Dim queryFilter As IQueryFilter = New QueryFilter()</SPAN><BR /><SPAN>queryFilter.SubFields = "DOCUMENTTYPE"</SPAN><BR /><BR /><SPAN>Dim queryDefinition As IQueryFilterDefinition2 = CType(queryFilter, IQueryFilterDefinition2)</SPAN><BR /><SPAN>queryDefinition.PrefixClause = "DISTINCT"</SPAN></BODY></HTML> Mon, 28 Oct 2013 13:10:14 GMT JasonCleaver 2013-10-28T13:10:14Z IQueryFilterDefinition2 Bug? https://community.esri.com/t5/arcobjects-sdk-questions/iqueryfilterdefinition2-bug/m-p/324785#M8474 <HTML><HEAD></HEAD><BODY><SPAN>I am running into an issue with the IQueryFilterDefinition2 interface.&nbsp; Here is what I am seeing.&nbsp; The PrefixClause works perfectly until I start an edit session.&nbsp; I can execute the query against a table, not a feature class, and get the value of DOCUMENTYPE from the row.&nbsp; Once I begin editing, the value of DOCUMENTYPE is null.&nbsp; I stop editing, run the query again, and it works.&nbsp; Additionally, the query is returning all of the records, so it is bacisally ignoring the DISTINCT prefic clause.</SPAN><BR /><BR /><SPAN>Dim queryFilter As IQueryFilter = New QueryFilter()</SPAN><BR /><SPAN>queryFilter.SubFields = "DOCUMENTTYPE"</SPAN><BR /><BR /><SPAN>Dim queryDefinition As IQueryFilterDefinition2 = CType(queryFilter, IQueryFilterDefinition2)</SPAN><BR /><SPAN>queryDefinition.PrefixClause = "DISTINCT"</SPAN></BODY></HTML> Mon, 28 Oct 2013 13:10:14 GMT https://community.esri.com/t5/arcobjects-sdk-questions/iqueryfilterdefinition2-bug/m-p/324785#M8474 JasonCleaver 2013-10-28T13:10:14Z