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

IQueryDef.SubFields Property (ArcObjects .NET 10.5 SDK)

ArcObjects Library Reference (GeoDatabase)

IQueryDef.SubFields Property

[Visual Basic .NET]
Public Property SubFields As String

[C#]
public string SubFields {get; set;}

[C++]
HRESULT get_SubFields(
  BSTR* SubFields
);

[C++]
HRESULT put_SubFields(
  BSTR SubFields
);

[C++]

Parameters
SubFields [out, retval]
  SubFields is a parameter of type BSTR
SubFields [in]
  SubFields is a parameter of type BSTR

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.