ADO Field Object

A field is a column of the data containing entries with the same data type.In ActiveX Data Object (ADO) Fields collection belongs exclusively to recordsets, and its members are Field objects. Field objects have methods and properties for storing and retrieving the data.

A ActiveX Data Object(ADO) Recordset object has a Fields collection made up of Field objects. Each Field object corresponds to the column in the Recordset.We use Value property of Field objects to set or return the data for the current record. Depending on the functionality the provider exposes, some collections, properties , or methods of a Field object may not be available.

Properties:

Property	Description
ActualSize	The actual length of a field value.
Attributes	One or more characteristics of a field. This property is read-only on UNIX.
DefinedSize	The defined size of a field.
Name	The name of a field.
NumericScale	The scale of numeric values in a field.
OriginalValue	The value of a field that existed in the record before any changes were made. This property is not currently supported on UNIX.
Precision	The degree of precision for numeric values in a field.
Type	The data type of the field.
UnderlyingValue	The current value of the field in the database. This property is not currently supported on UNIX.
Value	The value assigned to the field.

Method:

Method	Description
AppendChunk	Appends data to a large text or binary data field.
GetChunk	Returns all or a portion of the contents of a large text or binary data field.

AppendChunk Method Remarks (ADO Field Object)

Use the AppendChunk method on a Field object to fill it with long binary or character data. In situations where system memory is limited, you can use the AppendChunk method to manipulate long values in portions rather than in their entirety.

GetChunk Method Syntax (ADO Field Object)

Use the GetChunk method on a Field object to retrieve part or all of its long binary or character data. In situations where system memory is limited, you can use the GetChunk method to manipulate long values in portions rather than in their entirety.

Syntax:

variable = field.GetChunk( Size )

Share And Enjoy:These icons link to social bookmarking sites where readers can share and discover new web pages.