Databases access Objects

 

Objects Descriptions
Connection Represents a connection to a database. Allows to create and use procedures an queries in the SQL language. Provides access to the QueryDefs and Recordsets collections. An instance of this object can be retrieved by using the OpenConnection method of the Workspace object or from the Connections collection.
Connections A collection of the Connection objects. An instance of this collection can be retrieved from the Workspace object.
Database

A model of an open database. Demonstrates the structure of the database tables and relationship between them. Allows to create and use procedures an queries in the SQL language. Provides access to the TableDefs, QueryDefs, Recordsets and Relations collections. An instance of this object can be retrieved by using the OpenDatabase method of the Workspace object or from the Databases collection.

Databases A collection of the Database objects. An instance of this collection can be retrieved from the Workspace object.
DBEngine Controls Workspace objects and global transactions.
Field Describes a data field. Provides access to the Properties collection. An instance of this object can be retrieved from the Fields collection. The CreateField method of the Index and TableDef objects adds a new field to the corresponding objects and modifies the database accordingly.
Fields A collection of the Field objects. An instance of this collection can be retrieved from the Index, Recordset, Relation, TableDef objects.
Index Represents an index of a database table. Provides access to the Fields collection - the fields of the table, on which the given index is based, and Properties. An instance of this object can be retrieved from the Indexes collection. The CreateIndex method of the TableDef object creates a new index based on the selected fields of the table and modifies it accordingly when calling the Append method of the Indexes collection.
Indexes A collection of the Index objects. An instance of this collection can be retrieved from the TableDef object.
Parameter Represents a parameter of a stored procedure. An instance of this object can be retrieved by using the CreateParameter method or from the Parameters collection of the QueryDef object.
Parameters A collection of the Parameter objects. An instance of this collection can be retrieved from the QueryDef object.
Property Represents a property of a database object. An instance of the Property object can be retrieved by using the CreateProperty method or from the Properties collection.
Properties A collection of the Property objects. An instance of this collection can be retrieved from the Field, Index, Workspace objects.
QueryDef Represents a stored procedure in the SQL language. An instance of this object can be retrieved by using the CreateQueryDef method of the Connection and Database objects, or from the QueryDefs collection.
QueryDefs A collection of the QueryDef objects. An instance of this collection can be retrieved from the Connection, Database objects.
Recordset Represents the result of an SQL query or execution of a stored procedure. Provides methods for viewing and modifying the resulting data. Provides access to the Fields collection. An instance of this object can be retrived by using the OpenRecordset method of the Connection, Database, TableDef objects or from the Recordsets collection.
Recordsets A collection of the Recordset objects. An instance of this collection can be retrieved from the Connection, Database objects.
Relation Describes relations between the fields of the tables. Provides access to the Fields collection. An instance of this object can be retrieved by using the CreateRelation method of the Database object or from the Relations collection.
Relations A collection of the Relation objects. An instance of this collection can be retrieved from the Database object.
TableDef Represents an object that describes a data table. Controls the existing fields and indexes of the table and allows to create new ones. Provides access to the Fields and Indexes collections. An instance of this object can be retrieved with the help of the CreateTableDef method of the Database object or from the TableDefs collection.
TableDefs A collection of the TableDef objects. An instance of this collection can be retrieved from the Database object.
Workspace Controls connections to databases. Provides access to the Connections, Databases, Properties collections. Locally controls transactions. An instance of this object can be retrieved by using the CreateWorkspace method of the DBEngine object or from the Workspaces collection.
Workspaces A collection of the Workspace objects. An instance of this collection can be retrieved from the DBEngine object.