ADVERTISEMENTS

XML Certification
Download XML editor
Custom Programming

Table of contents
ADO Tutorial ADO HOME ADO Intro ADO Connect ADO Recordset ADO Display ADO Query ADO Sort ADO Add ADO Update ADO Delete ADO Demo ADO Speed Up ADO Objects ADO Command ADO Connection ADO Error ADO Field ADO Parameter ADO Property ADO Record ADO Recordset ADO Stream ADO DataTypes ADO Summary Examples ADO Examples Exam ADO Exam

Selected Reading
Web Statistics Web Glossary Web Hosting Web Quality W3Schools Tutorials W3Schools Forum Helping W3Schools

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.

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

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

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

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