DAO Topics
<<Back
Next>>

Errors Object

An Errors collection contains all stored Error objects, each of which pertains to a single operation involving DAO. The Errors object has one property, Count, which returns the number of objects in a collection. The Errors object has one method, Refresh(), whose syntax is Refresh, with no parameters. This method updates the the objects in a collection to reflect the current database's schema.


Error Object

An Error object contains details about data access errors, each of which pertains to a single operation involving DAO.


Error Object Properties
Property Description
HelpContext Returns a context ID as a long variable, for a topic in a Microsoft Windows Help file.
HelpFile Returns a String that is fully qualified path to the Help file.
Description Returns a descriptive string associated with an error. This is the default property for the Error object.
Number Returns a numeric value specifying an error.
Source Returns the name of the object or application that originally generated the error.



Fields Object

A Fields collection contains all stored Field objects of an Index, QueryDef, Recordset, Relation, or TableDef object. The Field object has one property, Count, which counts the number of objects in a collection.


Fields Object Methods
Append() Adds a new DAO object to a collection.
Delete() Deletes a persistent object from a collection.
Refresh() Updates the object in a collection to reflect the current database's schema.


Field Object

A Field object represents a column of data with a common data type and common set of properties.


Field Object Properties
Property Description
CollatingOrder Returns a value that specifies the sequence of the sort order in text for string comparison or sorting.
Attributes Sets or returns a value that returns one or more characteristics of a Field, Relation, or TableDef object.
AllowZeroLength Sets or returns a value that indicates whether a zero-length ("") string is a valid setting for a Value property of the Field object with a Text or Memo data type.
DataUpdatable Returns a value that indicates whether the data in the field represented by a Field object is updatable.
ForiegnName Sets or returns a value that specifies the name of the Field object in a foreign table that corresponds to a field in a primary table for relationship.
DefaultValue Sets or returns the default value of a field object. For a field object not yet appended to the fields collection, this property is read/write.
OrdinalPosition Sets or returns the relative position of a Field object within a Fields collection. For an object not yet appended to the Fields collection, this property is read/write.
Name Sets or returns a user-defined name for a DAO object. For an object not appended to a collection, this property is read/write.
Required Sets or returns a value that indicates whether a Field object requires a non-Null value or whether all the fields in an index must have a value.
Size Sets or returns a value that indicates the maximum size, in bytes, of a Field object.
SourceField Returns a value that indicates the name of the field that is the original source of the data for a Field object
SourceTable Returns a value that indicates the name of the table that is the original source of data for a Field object.
Type Sets or returns a value that indicates the operational type or data type of an object.
ValidateOnSet Sets or returns a value that specifies whether the value of a field object is immediately validated when the object's Value property is set.
Value Sets or returns the value of an object.
ValidationText Sets or returns a value that specifies the text of the message that your application displays if the value of a Field object doesn't satisfy the validation rule specified by the ValidationRule property setting.
ValidationRule Sets or returns a value that indicates the data in a field as it's changed or added to a table.
OriginalValue Returns the value of a Field in the database that existed when the last batch update began.
FieldSize Returns the number of bytes used in the database (rather than in memory) of a memo or Long Binary Field object in the Fields collection of a Recordset object.
VisibleValue Returns a value currently in the database that is newer than the OriginalValue property, as determined by a batch update conflict.



Field Object Methods
Method Description
AppendChunk() Appends a data from a string expression to a Memo or Long Binary Field object in a Recordset.
CreateProperty() Creates a new user-defined Property object.
GetChunk() Returns all or a portion of the contents of a Memo or Long binary field object in the Fields collection of a Recordset object.





<<Back
top
Next>>





Copyright� 2000 by Noel