IFields Interface

Provides access to members that return information about the fields.

Product Availability

Description

The Fields object represents a collection of columns in a table. The term field is synonymous with column. Each table in a database has an ordered collection of fields, there is always at least one field in a table. The ordered collection behaves like a list, so it is possible to access individual fields by a numbered position (or index) in the list.

Members

	All Properties Methods	Description
	Field	The field at the specified index in the fields collection.
	FieldCount	The number of fields in the fields collection.
	FindField	Finds the index of the named field in the fields collection.
	FindFieldByAliasName	Finds the index of the field with the alias name in the fields collection.

CoClasses that implement IFields

Remarks

The IFields interface provides information about a Fields collection and also provides access to individual fields. This example finds any fields in a feature class which have a distinct alias name.

Set pFields = pFeatureClass.Fields
For i = 0 To (pFields.FieldCount - 1)
  Set pField = pFields.Field(i)
  If (pField.Name <> pField.AliasName) Then
    Debug.Print pField.Name & “:” & pField.AliasName
  End If
Next i

When using IFields::FindField, remember that there are equivalent methods on IClass and ICursor—they are shortcuts which save you having to get the Fields collection.

When programming with ArcMap, there is a distinction between IFields and two other interfaces, ILayerFields and ITableFields. ILayerFields is particular to an ArcMap layer, so for example, an alias name belongs to the field as defined in that layer rather than being stored with the underlying table.

Send feedback on this page