ArcObjects Library Reference (GeoDatabase)  

IQueryDef.SubFields Property

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.

See Also

IQueryDef Interface

.NET Related Topics

Geodatabase | Joining data | Querying geodatabase tables