ADO: ActiveX Data Objects

Name

Recordset.Fields Collection — (Versions 2.0, 2.1, 2.5, 2.6)

Synopsis

record.Fields

The Field collection contains multiple Field objects for the current Recordset object, one for each column in the Recordset object.

Datatype

Fields (Collection object)

Description

The Fields collection of a Recordset object can be populated before opening a Recordset object by calling the Refresh method of the Fields collection.

Field objects can be added to the collection either by calling the Field.Append method or by referencing by name a Field object that is not already part of the collection. Calling the Field.Update method will add the field to the collection, if possible, within the data source. Until this moment, the Field.Status property will return adFieldPendingInsert.

See Also

Field.Append Method, Field.Refresh Method, Field.Update Method