| |
Relation Object
A Relation object represents a relationship between fields in a tables or queries. The Relation object has just one method, CreateField(), which creates a new field. It has the following syntax:
Set field = object.CreateField (name, type, size)
The field parameter is an object variable that represents the Field object that you want to create. The object parameter is an object variable that represents the Index, Relation, or TableDef object for which you want to create the new Field object. The type parameter is a constant that determines the data type of the new Field object. The size parameter is an Integer that indicates the maximum size, in bytes, of a Field object that contains text.
Relation Object Properties
| Property |
Description |
| Attributes |
Sets or returns a value that indicates one or more characteristics of a Relation. |
| ForeignTable |
Sets or returns the name of the foreign table in a relationship. |
| 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. |
| Table |
Indicates the name of a Relation object's primary table. |
| PartialReplica |
Sets or returns a value on a Relation object, indicating whether that relation should be considered when populating a partial replica from a full replica. |
TableDefs Object
A TableDefs collection contains all stored TableDef objects in a database. The TableDefs object has one property, Count, which return the number of objects in a collection.
TableDefs Object Method
| Method |
Description |
| Append() |
Adds a new DAO object to a collection. |
| Delete() |
Deletes a persistent object from a collection. |
| Refresh() |
Updates the objects in a collection to reflect the current database's schema. |
TableDef Object
A TableDef object represents the stored definition of a base table or a linked table.
TableDef Object Properties
| Property |
Description |
| Connect |
Sets or returns a value that provides information about the source of an open connection, an open database, a database used in a pass-through query, or a linked table. |
| Attributes |
Sets or returns a value that indicates one or more characteristics of a TableDef object. |
| ConflictTable |
Returns the name of a conflict table containing the database records that conflicted during the synchronization of two replicas. |
| DateCreated |
Returns the date and time that an object was created, or date and time a base table was created if the object is a table-type Recordset object. |
| LastUpdated |
Returns the date and time of the most recent change made to an object, or to a base table if the object is a table-type Recordset object. |
| 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. |
| RecordCount |
Returns the number of records accessed in a Recordset object, or the total number of records in a TableDef object. |
| SourceTableName |
Sets or returns a value that specifies the name of a linked table or the name of a base table. |
| Updatable |
Returns a value that indicates whether you can change a DAO 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. |
| Replicable |
Sets or returns a value that determines whether a database object in a database can be replicated. |
| KeepLocal |
Sets or returns a value on a table, query, form, report, macro, or module that you do not want to replicate when the database is replicated. |
| ReplicaFilter |
Sets or returns a value on a TableDef object within a partial replica that indicates which subset of records is replicated to that table from a full replica. |
TabelDef Object Methods
Copyright� 2000 by Noel
|