Sun Chili!Soft ASP Sun Chili!Soft
ASP Sun Microsystems

 

ADO Field Object

The ADO Field Object represents a column of data with a common data type.

ADO Field Object Collections

ADO Properties Collection

All Property objects for a specific instance of a Field object. This collection is not currently supported on UNIX.

ADO Field Object Methods

ADO Field Object AppendChunk Method

Appends data to a large text or binary data field.

ADO Field Object GetChunk Method

Returns all or a portion of the contents of a large text or binary data field.

ADO Field Object Properties

ADO Field Object ActualSize Property

The actual length of a field value.

ADO Field Object Attributes Property

One or more characteristics of a field. This property is read-only on UNIX.

ADO Field Object DefinedSize Property

The defined size of a field.

ADO Field Object Name Property

The name of a field.

ADO Field Object NumericScale Property

The scale of numeric values in a field.

ADO Field Object OriginalValue Property

The value of a field that existed in the record before any changes were made.

ADO Field Object Precision Property

The degree of precision for numeric values in a field.

ADO Field Object Type Property

The data type of the field.

ADO Field Object UnderlyingValue Property

The current value of the field in the database.

ADO Field Object Value Property

The value assigned to the field.

ADO Field Object Remarks

A ADO Recordset Object has an ADO Fields Collection made up of Field objects. Each Field object corresponds to a column in the recordset. You use the ADO Field Object Value Property of Field objects to set or return data for the current record. Depending on the functionality the provider exposes, some collections, methods, or properties of a Field object may not be available.

The collections, methods, and properties of a Field object are used to:

·   return the name of a field with the ADO Field Object Name Property.

·   view or change the data in the field with the ADO Field Object Value Property.

·   return the basic characteristics of a field with the ADO Field Object Type Property, ADO Field Object Precision Property, and ADO Field Object NumericScale Property properties.

·   return the declared size of a field with the ADO Field Object DefinedSize Property.

·   return the actual size of the data in a given field with the ADO Field Object ActualSize Property.

·   determine what types of functionality are supported for a given field with the ADO Field Object Attributes Property and ADO Properties Collection.

·   manipulate the values of fields containing long binary or long character data with the ADO Field Object AppendChunk Method and ADO Field Object GetChunk Method methods.

·   resolve discrepancies in field values during batch updating with the ADO Field Object OriginalValue Property and UnderlyingValue properties (if the provider supports batch updates).

Note

All metadata properties (Name, Type, DefinedSize, Precision, and NumericScale) are available before opening the Field object's recordset. Setting them at that time is useful for dynamically constructing forms.

Copyright 2002 Sun Microsystems, Inc. All rights reserved. Legal Notice.