Please note, this is a STATIC archive of website www.w3schools.com from 05 May 2020, cach3.com does not collect or store any user information, there is no "phishing" involved.
THE WORLD'S LARGEST WEB DEVELOPER SITE

ADO Field Object


Field Object

The ADO Field object contains information about a column in a Recordset object. There is one Field object for each column in the Recordset.


ProgID

set objField=Server.CreateObject("ADODB.field")

Properties

Property Description
ActualSize Returns the actual length of a field's value
Attributes Sets or returns the attributes of a Field object
DefinedSize Returns the defined size of a field
Name Sets or returns the name of a Field object
NumericScale Sets or returns the number of decimal places allowed for numeric values in a Field object
OriginalValue Returns the original value of a field
Precision Sets or returns the maximum number of digits allowed when representing numeric values in a Field object
Status Returns the status of a Field object
Type Sets or returns the type of a Field object
UnderlyingValue Returns the current value of a field
Value Sets or returns the value of a Field object

Methods

Method Description
AppendChunk Appends long binary or character data to a Field object
GetChunk Returns all or a part of the contents of a large text or binary data Field object

Collections

Collection Description
Properties Contains all the Property objects for a Field object