Previous PageNext Page

9.5 Field Object

Represents a column of data with a common data type.
 

Collections

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

Methods

AppendChunk
 
Appends data to a large text or binary data field.
 
GetChunk
 
Returns all or a portion of the contents of a large text or binary data field.
 

Properties

ActualSize
 
The actual length of a field value.
 
Attributes
 
One or more characteristics of a field. This property is read-only on UNIX.
 
DefinedSize
 
The defined size of a field.
 
Name
 
The name of a field.
 
NumericScale
 
The scale of numeric values in a field.
 
OriginalValue
 
The value of a field that existed in the record before any changers were made.
 
Precision
 
The degree of precision for numeric values in a field.
 
Type
 
The data type of the field.
 
UnderlyingValue
 
The current value of the field in the database.
 
Value
 
The value assigned to the field.
 

Remarks

A Recordset object has a Fields collection made up of Field objects. Each Field object corresponds to a column in the Recordset. You use the 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 Name property.
  • view or change the data in the field with the Value property.
  • return the basic characteristics of a field with the Type, Precision, and NumericScale properties.
  • return the declared size of a field with the DefinedSize property.
  • return the actual size of the data in a given field with the ActualSize property.
  • determine what types of functionality are supported for a given field with the Attributes property and Properties collection.
  • manipulate the values of fields containing long binary or long character data with the AppendChunk and GetChunk methods.
  • resolve discrepancies in field values during batch updating with the OriginalValue 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 © 2000 Chili!Soft

Previous PageTop Of PageNext Page