| |
Group Object
A Groups collection contains all stored Group objects of the Workspace or user account. The Groups object has one property, Count, which returns the number of objects in a collection.
Groups 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. |
Group Object
A Group object represents a group of user accounts that have common access permissions when a Workspace object operates as a secure workgroup. The Group object has just one method, CreateUser(), which creates a new User object. It has the following syntax:
Set user = object.CreateUser (name, pid,_
password)
The User parameter is an object variable that represents the User object that you want to create. The Object parameter is an object variable that represents the Group or Workspace object for which you want to create the new User object. The name parameter is a String that uniquely names the new User object. The pid parameter is a String containing the PID of a user account. The password parameter is a String containing the password for the new User object. The password can be up to 14 characters long and can include any characters except the ASCII character 0 (null).
Group Object Properties
| Property |
Description |
| 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. |
| PID |
Sets the personal identifier (PID) for either a group or user account. |
Indexes Object
An Indexes collection contains all the stored Index objects of a TableDef object. The Indexes object has one property, Count, which returns the number of objects in a collection.
Indexes Object Methods
| 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. |
Index Object
Index objects specify the number of records accessed from a database tables and whether duplicate records are accepted, providing efficient access to data. For external databases, Index objects describe the indexes established for external tables.
Index Object Properties
| Property |
Description |
| Clustered |
Sets or returns a value that indicates whether an index object represents a clustered index for a table. |
| Foreign |
Returns a value that indicates whether an Index object represents a foreign key in a table. |
| DistinctCount |
Returns a value that indicates the number of unique values for the Index objects that are included in the associated table. |
| IgnoreNulls |
Sets or returns a value that indicates whether records that have Null values in their index fields have index entries. |
| 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. |
| Primary |
Sets or returns a value that indicates whether an Index object represents a primary key index for a table. |
| 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. |
| Unique |
Sets or returns a value that indicates whether an Index object represents a unique (key) index for a table. |
Index Object Methods
Parameters Object
A Parameters collection contains all the Parameter objects of a QueryDef object. The Parameters object has one property Count, which returns the number of objects in a collection. The Parameters object has one method, Refresh(), whose syntax is Refresh, with no parameters. This method updates the objects in a collection to reflect the current database's schema.
Parameter Object
A Parameter object represents a value supplied to a query. The Parameter is associated with a QueryDef object created from a query. The Parameter object does not have any methods.
Parameter Object Properties
| Property |
Description |
| Name |
Sets or returns the user-defined name for DAO object. For an object not appended to a collection, this property is read/write. |
| Type |
Sets or returns a value that indicates the operational type or the data type of an object. |
| Value |
Sets or returns the value of an object. |
| Direction |
Sets or returns a value that indicates whether a Parameter object represents an input parameter, or an output parameter, both, or the return value from the procedure. |
Properties Object
A Properties collection contains all the Property objects for a specific instance of an object. The Properties object has one property, Count, which returns the number of objects in a collection.
Properties Object Methods
| Method |
Description |
| Append() |
Adds a new DAO object to a collection.0 |
| Delete() |
Deletes a persistent object from a collection |
| Refresh() |
Updates the objects in a collection to reflect the current database's schema. |
Property Object
A Property object represents a built-in or user-defined characteristic of a DAO object.
Property Object Properties
| Property |
Description |
| Inherited |
Returns a value that indicates whether a Property object is inherited from an underlying 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. |
| Type |
Sets or returns a value that indicates the operational type or data type of an object. |
| Value |
Sets or returns the value of an object. |
Copyright� 2000 by Noel
|