Field Object
A Field object represents a column of data with a common data type.
Collections
Properties
Properties
ActualSize, Attributes,
DefinedSize, Name,
NumericScale, OriginalValue,
Precision, Type, UnderlyingValue,
Value
Methods
AppendChunk, GetChunk
Remarks
A Recordset object has a Fields
collection made up of Field objects. Each Field object
corresponds to a column in the Recordset. You use the Value
property of Field objects to set or return data for the current record.
Depending on the functionality the provider exposes, some collections,
methods, or properties of a Field object may not be available.
With the collections, methods, and properties of a Field object, you
can do the following:
· Return the name of a field with the Name
property.
· View or change the data in a Recordset
with the Value property.
· Return the basic characteristics of a
field with the Type, Precision,
and NumericScale properties.
· Return the declared size of a field with
the DefinedSize property.
· Return the actual size of the data in a
given field with the ActualSize property.
· Determine what types of functionality
are supported for a given field with the Attributes
property and Properties collection.
· Manipulate the values of fields
containing long binary or character data with the AppendChunk
and GetChunk methods.
· Resolve discrepancies in field values
during batch updating with the OriginalValue
and UnderlyingValue properties.
To refer to a Field object in a collection by its ordinal number or by
its Name property setting, use any of the following syntax forms:
recordset.Fields.Item(0)
recordset.Fields.Item("name")
recordset.Fields(0)
recordset.Fields("name")
recordset(0)
recordset("name")
recordset![name]
See Also
Fields, Item, Recordset
| 
