The ActiveX Data Object (ADO) module enables programs written in C++ and Visual Basic to connect to different databases and SQL servers. It includes several objects, such as the ADO field object. This object represents a column in the RecordSet
object. For each column in the RecordSet
, there is one Field Object
.
The Field
object has certain methods, properties, and collections associated with it, which are described below.
AppendChunk
: This appends the long binary or character data to a field object.
GetChunk
: This returns all or part of the contents of the large text or binary data field object.
Name
: This sets or returns the name of the field object.
Status
: This returns the status of a field object, which is a value of type FieldStatusEnum
. This tells us whether fields have been added or deleted.
Type
: This sets or returns the type of the field object of type DataTypeEnum
.
Value
: This sets or returns the value of the Field
object. Its default value is on the Type property.
UnderlyingValue
: This returns the current value of a field in the database.
OriginalValue
: This returns the original value of a field before any changes were made to the field.
Precision
: This sets or returns a byte
value for the maximum number of digits allowed when we want to represent numeric values in a field object.
Attributes
: This sets or returns the attributes of the field object.
ActualSize
: This returns the actual size of a field object as a long
value. It is a read-only property.
DefinedSize
: This returns the capacity of a field object as the number of bytes in the form of a long
value.
NumericScale
: This sets or returns the total number of digits that are allowed to the right of the decimal point for numeric values in the field object as a byte
value. It is normally a read-only property but may be read/write if certain properties are changed.
Properties
: This contains all the property objects for a field object.