topic Re: IQueryFilter.Subfields does not work. in ArcObjects SDK Questions

IQueryFilter.Subfields does not work.

ESRICustomer — Wed, 30 Jun 2010 20:33:14 GMT

Language: VB.NET
ArcObjects version: 9.3.x

How come when I do this...

QueryFilter.SubFields = ""
QueryFilter.AddField(SomeFieldName)

And then this...

Debug.Print QueryFilter.SubFields

I get this retarded output...

"*"
Which to me, and according to the help, illustrates that Subfields just ignores whatever you do and doesn't work.

Re: IQueryFilter.Subfields does not work.

KirkKuykendall — Thu, 01 Jul 2010 18:39:14 GMT

try this:

QueryFilter.SubFields = "FieldA"
QueryFilter.AddField("FieldB")

Re: IQueryFilter.Subfields does not work.

NeilClemmons — Fri, 02 Jul 2010 11:34:12 GMT

The SubFields property and AddField method work as documented. The SubFields property is a comma-delimited list of field names which is set to "*" by default. "*" is standard SQL for all fields. AddField adds a field name to this list. If you call AddField when SubFields is set to "*", then it does nothing because adding a field to the list when it's already set for all fields would be redundant. If you set the SubFields property to a single field name or a comma-delimited list of field names, then call AddField, it will add that field to the list (see Kirk's example above).