Class TDAODataset (unit DAODataset)

Inherits from

TDataset

Encapsulates DAO recordset funtionality for descendent dataset objects.
TDAODataset is a dataset object that defines DAO recordset functionality for a dataset. Your applications will never use TDAODataset object directly. Instead they use descendents of TDAODataset, such as TDAOQuery, TDAOTable and TDAOQueryDef, which inherits its database related properties and methods.

Functions

function Locate(const KeyFields: string; const KeyValues: Variant; Options: TLocateOptions): Boolean;

Searches the dataset for a specified record and makes that record the current record.
Currently only [loPartialKey] or empty ([]) locate options supported by Diamond Access.

Note

Locate method NOT supported by TDAOTable, opened with OpenType = db_Open_Table.


function Lookup(const KeyFields: string; const KeyValues: Variant; const ResultFields: string): Variant;

Retrieves field values from a record that matches specified search values.

Note

Lookup method NOT supported by TDAOTable, opened with OpenType = db_Open_Table.

Properties

property Active :

Specifies whether or not a dataset is open.


property BlockType : TDAOBlockType

Specifies DAO Recordset blocking type (Look into DAO 3.5 help for additional details).

BlockType is set from the following values:
db_Optimistic A type of locking in which the data page containing one or more record, including the record being edited, is unavailable to other users only while the record is being updated
db_Pessimistic A type of locking in which the data page containing edited record is blocked by a call of Edit method
db_ReadOnly Interdiction to the users on modification in dataset (Recordset)


property Database : TDAODatabase

Specifies the name of the database to associate with this database component.


property Parameters : TDAOOpenParameters

Any combination of the following constants specifying the characteristics of the DAO Recordset object (Look into DAO 3.5 help for additional details).
db_AppendOnly The addition of new records in is authorized only to users
db_SeeChanges Generation of an exception, if one user has changed the data, edited by other user
db_DenyWrite Interdiction to other users to change or to add records
db_DenyRead Interdiction to other users on reading of the data in the table (only for Recordsets opened with dbOpenTable parameter).

Variables

_Recordset : Recordset;

Provides interface to native DAO Recordset object.