Name
Field Object — (Versions 2.0, 2.1, 2.5, 2.6)
Synopsis
Dim field
As ADODB.Field
The Field object represents an individual column within a Recordset or a Record object’s Fields collection. A Field contains metadata properties that define its datatype, size, and precision.
Applies To
- Fields
Contains a group of Field objects that represent the fields of the current record in an open Recordset object.
Collections
- Properties
Contains characteristics specific to the Field object for the currently used provider.
Methods
- AppendChunk
Appends data to a large data or binary field.
- GetChunk
Returns the specified number of bytes or characters from the specified field.
Properties
- ActualSize
Returns the actual length of a field’s value.
- Attributes
Sets or returns specific characteristics about the Field object.
- DataFormat
The DataFormat property for the Field object is not documented at all in the ADO help files -- however, the DataFormat property is used in other Microsoft objects outside of ADO.
- DefinedSize
Represents the size, in bytes, of the capacity of a Field object’s datatype.
- Name
Specifies the name for the current Field object.
- NumericScale
Indicates the scale of numeric values in the current Field object.
- OriginalValue
Returns the value that belonged to a field before any changes were made to it.
- Precision
Represents the degree of precision of a numeric value within the current Field object.
- Status
Indicates the status of the current Field object.
- Type
Indicates the datatype of the Field’s Value property.
- UnderlyingValue ...
Get ADO: ActiveX Data Objects now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.