DevGuru ADO Field Object



			OBJECT: Field Field The ADO Field object contains information about a single field (column) in a Recordset object. A Recordset object is composed of a collection of zero or more Field objects. Appropriately, this collection is called the Fields Collection. Only the Record and Recordset objects have a Fields Collection. PROPERTIES ActualSize Property Returns a long value that is the actual length of a Field object's value. Syntax: fieldobject. ActualSize Attributes Property Returns a long value that is the sum of one or more FieldAttributeEnum values that define the characteristics of a Field object. Syntax: fieldobject. Attributes DataFormat Property Only used with Visual Basic 6.0 or Visual J++ 6.0 (which include a DataFormat object). It is recommended that you reference VB6 and VJ++6 documentation. Sets or returns the format for displaying data. Syntax: fieldobject. DataFormat DefinedSize Property Returns a long value that is the defined (maximum possible) size (data capacity) of a Field object. Syntax: fieldobject. DefinedSize Name Property Sets or returns a string value that is the name of the Field object. Syntax: fieldobject. Name NumericScale Property Sets or returns a byte value that is the number of digits allowed to the right of the decimal point for a numeric Field object. Syntax: fieldobject. NumericScale OriginalValue Property Returns a variant that is the value of a field in the database before any changes were made in the current session. Syntax: fieldobject. OriginalValue Precision Property Sets or returns a byte value that is the maximum number of digits allowed in a numeric Field object. Syntax: fieldobject. Precision Status Property Returns a FieldStatusEnum value that allows you to determine if a field has been successfully added. Syntax: fieldobject. Status Type Property Sets or returns a DataTypeEnum value that specifies the data type. Syntax: fieldobject. Type UnderlyingValue Property Returns a variant that is the current field value as stored in the database. Syntax: fieldobject. UnderlyingValue Value Property Returns a variant that is the current (visible) field value in the current recordset. Syntax: fieldobject. Value COLLECTIONS Properties Collection A collection of Property objects. Each Property object contains a provider-specific property. METHODS AppendChunk Method Used to append a large amount (i.e., a large chunk) of text or binary data to a Field object. Syntax: fieldobject. AppendChunk(data) GetChunk Method Returns a variant that contains the specified amount (size) of binary or text data. Syntax: fieldobject. GetChunk(size)