This document is archived and information here might be outdated.  Recommended version.

IQueryDef.SubFields Property (ArcObjects .NET 10.8 SDK)
ArcObjects Help for .NET developers > ArcObjects Help for .NET developers > ArcObjects namespaces > Geodatabase > ESRI.ArcGIS.GeoDatabase > Interfaces > IQ > IQueryDef Interface > IQueryDef.SubFields Property
ArcGIS Developer Help

IQueryDef.SubFields Property

The comma delimited list of field names for the query.

[Visual Basic .NET]
Public Property SubFields As String
public string SubFields {get; set;}
HRESULT get_SubFields(
  System.String* SubFields
HRESULT put_SubFields(
  BSTR SubFields
SubFields [out, retval]

SubFields is a parameter of type BSTR* SubFields [in]
SubFields is a parameter of type BSTR

Product Availability

Available with ArcGIS Engine, ArcGIS Desktop, and ArcGIS Server.


SubFields returns or sets a comma delimited list of fields.


The following formats are used for the SubFields property of a QueryDef against an ArcSDE datasource:

Format 1: "*"
This returns all fields on all tables. If duplicate column names are found, the field names will be prefixed with the table name (table.field_name).

Format 2: "field1,field2,field3"
Returns only the fields requested. (Separate field names by commas but do not add a space after or before the comma)

Format 3: "table1.*,table2.field1,table3.field2"
Returns all of the fields from table1, field1 from table2 and field 2 from table3.

See Also

IQueryDef Interface