The comma delimited list of field names for the query.
[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
Product Availability
Available with ArcGIS Engine, ArcGIS Desktop, and ArcGIS Server.
Description
SubFields returns or sets a comma delimited list of fields.
Remarks
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.
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.