topic VB.Net ITableSort and QueryFilter SubFields in ArcObjects SDK Questions https://community.esri.com/t5/arcobjects-sdk-questions/vb-net-itablesort-and-queryfilter-subfields/m-p/349008#M9224 <HTML><HEAD></HEAD><BODY><SPAN>ESRI is promoting the use of Subfields on queries to limit the number of fields read by a search cursor to reduce the processing time involved in retrieving data through a cursor.</SPAN><BR /><BR /><SPAN>I just wanted to let others know that I have found a gotcha in VB.NET (VS 2010 with ArcGIS Desktop 10.0) when using the QueryFilter Subfields property in combination with an ITableSort interface.&nbsp; If the ITableSort's QueryFilter property is set to a QueryFilter that has Subfields specified, the Sort will not return any Rows.&nbsp; This occurs even if the Subfields list of the QueryFilter is identical to the list that is assigned to the Fields property of the TableSort.&nbsp; The same behavior occurs when the Cursor that is assigned to the TableSort's Cursor property was originally generated using a QueryFilter that had Subfields specified.</SPAN><BR /><BR /><SPAN>The </SPAN><A href="http://help.arcgis.com/en/sdk/10.0/arcobjects_net/conceptualhelp/index.html#//0001000001mn000000">help for the ITableSort</A><SPAN> interface says:</SPAN><BR /><BR /><SPAN>"If the IQueryFilter.Subfields property is set, it is ignored as the ITableSort.Fields property always takes precedence."</SPAN><BR /><BR /><SPAN>But based on what I have seen that is apparently not the case, since the only way I have been able to get Rows returned from the ITableSort was to set the input QueryFilter SubFields property to "".</SPAN></BODY></HTML> Thu, 11 Oct 2012 20:28:29 GMT RichardFairhurst 2012-10-11T20:28:29Z VB.Net ITableSort and QueryFilter SubFields https://community.esri.com/t5/arcobjects-sdk-questions/vb-net-itablesort-and-queryfilter-subfields/m-p/349008#M9224 <HTML><HEAD></HEAD><BODY><SPAN>ESRI is promoting the use of Subfields on queries to limit the number of fields read by a search cursor to reduce the processing time involved in retrieving data through a cursor.</SPAN><BR /><BR /><SPAN>I just wanted to let others know that I have found a gotcha in VB.NET (VS 2010 with ArcGIS Desktop 10.0) when using the QueryFilter Subfields property in combination with an ITableSort interface.&nbsp; If the ITableSort's QueryFilter property is set to a QueryFilter that has Subfields specified, the Sort will not return any Rows.&nbsp; This occurs even if the Subfields list of the QueryFilter is identical to the list that is assigned to the Fields property of the TableSort.&nbsp; The same behavior occurs when the Cursor that is assigned to the TableSort's Cursor property was originally generated using a QueryFilter that had Subfields specified.</SPAN><BR /><BR /><SPAN>The </SPAN><A href="http://help.arcgis.com/en/sdk/10.0/arcobjects_net/conceptualhelp/index.html#//0001000001mn000000">help for the ITableSort</A><SPAN> interface says:</SPAN><BR /><BR /><SPAN>"If the IQueryFilter.Subfields property is set, it is ignored as the ITableSort.Fields property always takes precedence."</SPAN><BR /><BR /><SPAN>But based on what I have seen that is apparently not the case, since the only way I have been able to get Rows returned from the ITableSort was to set the input QueryFilter SubFields property to "".</SPAN></BODY></HTML> Thu, 11 Oct 2012 20:28:29 GMT https://community.esri.com/t5/arcobjects-sdk-questions/vb-net-itablesort-and-queryfilter-subfields/m-p/349008#M9224 RichardFairhurst 2012-10-11T20:28:29Z Re: VB.Net ITableSort and QueryFilter SubFields https://community.esri.com/t5/arcobjects-sdk-questions/vb-net-itablesort-and-queryfilter-subfields/m-p/349009#M9225 <HTML><HEAD></HEAD><BODY><SPAN>I had experienced some performance and memory issues with ITableSort in the past. I normally use IQueryDef.PostFixClause to include "orderby" clause in the database query rather than using ITableSort . You can even specify the Subfields in IQueryDef. It can be used with ArcSDE, Personal and File Geodatabase data sources.</SPAN></BODY></HTML> Fri, 12 Oct 2012 16:34:44 GMT https://community.esri.com/t5/arcobjects-sdk-questions/vb-net-itablesort-and-queryfilter-subfields/m-p/349009#M9225 sapnas 2012-10-12T16:34:44Z