Base Class Members
Data Members
Construction
Attributes
Recordset Update Operations
Recordset Navigation Operations
Other Recordset Operations
Overridables
Base Class Members
Data Members
Contains a flag indicating whether fields are automatically marked as changed. |
|
Contains the number of field data members in the recordset class and the number of columns selected by the recordset from the data source. |
|
Contains the number of parameter data members in the recordset class — the number of parameters passed with the recordset's query |
|
A pointer to the DAO interface underlying the recordset object. |
|
Source database for this result set. Contains a pointer to a CDaoDatabase object. |
|
Contains a string used to construct a SQL WHERE statement. |
|
Contains a string used to construct a SQL ORDER BY statement. |
Construction
Constructs a CDaoRecordset object. |
|
Closes the recordset. |
|
Creates a new recordset from a table, dynaset, or snapshot. |
Attributes
Returns nonzero if new records can be added to the recordset via the AddNew member function. |
|
Returns nonzero if the recordset supports bookmarks. |
|
Returns nonzero if Requery can be called to run the recordset's query again. |
|
Returns nonzero if you can scroll through the records. |
|
Returns nonzero if the data source supports transactions. |
|
Returns nonzero if the recordset can be updated (you can add, update, or delete records). |
|
Returns a CString containing the name of the index most recently used on an indexed, table-type CDaoRecordset. |
|
Returns the date and time the base table underlying a CDaoRecordset object was created |
|
Returns the date and time of the most recent change made to the design of a base table underlying a CDaoRecordset object. |
|
Returns a value that indicates the state of editing for the current record. |
|
Used to determine the most recently added or updated record. |
|
Returns a CString containing the name of the recordset. |
|
Retrieves the current value of the specified parameter stored in the underlying DAOParameter object. |
|
Returns the number of records accessed in a recordset object. |
|
Gets the SQL string used to select records for the recordset. |
|
Called to determine the type of a recordset: table-type, dynaset-type, or snapshot-type. |
|
Returns a CString containing the value that validates data as it is entered into a field. |
|
Retrieves the text that is displayed when a validation rule is not satisfied. |
|
Returns nonzero if the recordset has been positioned before the first record. There is no current record. |
|
Returns nonzero if the recordset is positioned on a deleted record. |
|
Returns nonzero if the recordset has been positioned after the last record. There is no current record. |
|
Returns nonzero if the specified field in the current record has been changed. |
|
Returns nonzero if the specified field in the current record is Null (having no value). |
|
Returns nonzero if the specified field in the current record can be set to Null (having no value). |
|
Returns nonzero if Open has been called previously. |
|
Called to set an index on a table-type recordset. |
|
Sets the current value of the specified parameter stored in the underlying DAOParameter object |
|
Sets the current value of the specified parameter to Null (having no value). |
Recordset Update Operations
Prepares for adding a new record. Call Update to complete the addition. |
|
Cancels any pending updates due to an Edit or AddNew operation. |
|
Deletes the current record from the recordset. You must explicitly scroll to another record after the deletion. |
|
Prepares for changes to the current record. Call Update to complete the edit. |
|
Completes an AddNew or Edit operation by saving the new or edited data on the data source. |
Recordset Navigation Operations
Locates the first, next, previous, or last location of a particular string in a dynaset-type recordset that satisfies the specified criteria and makes that record the current record. |
|
Locates the first record in a dynaset-type or snapshot-type recordset that satisfies the specified criteria and makes that record the current record. |
|
Locates the last record in a dynaset-type or snapshot-type recordset that satisfies the specified criteria and makes that record the current record. |
|
Locates the next record in a dynaset-type or snapshot-type recordset that satisfies the specified criteria and makes that record the current record. |
|
Locates the previous record in a dynaset-type or snapshot-type recordset that satisfies the specified criteria and makes that record the current record. |
|
Returns the record number of a recordset object's current record. |
|
Returns a value that represents the bookmark on a record. |
|
Returns the position of the current record as a percentage of the total number of records. |
|
Positions the recordset to a specified number of records from the current record in either direction. |
|
Positions the current record on the first record in the recordset. |
|
Positions the current record on the last record in the recordset. |
|
Positions the current record on the next record in the recordset . |
|
Positions the current record on the previous record in the recordset. |
|
Locates the record in an indexed table-type recordset object that satisfies the specified criteria for the current index and makes that record the current record. |
|
Sets the record number of a recordset object's current record. |
|
Positions the recordset on a record containing the specified bookmark. |
|
Sets the position of the current record to a location corresponding to a percentage of the total number of records in a recordset. |
Other Recordset Operations
Fills all or a part of a local cache for a recordset object that contains data from an ODBC data source. |
|
Returns a value that specifies the number of records in a dynaset-type recordset containing data to be locally cached from an ODBC data source. |
|
Returns a value that specifies the bookmark of the first record in the recordset to be cached. |
|
Returns a value that represents the number of fields in a recordset. |
|
Returns specific kinds of information about the fields in the recordset. |
|
Returns the value of a field in a recordset. |
|
Retrieves the number of indexes in a table underlying a recordset. |
|
Returns various kinds of information about an index. |
|
Returns a value that indicates the type of locking that is in effect during editing. |
|
Runs the recordset's query again to refresh the selected records. |
|
Sets a value that specifies the number of records in a dynaset-type recordset containing data to be locally cached from an ODBC data source. |
|
Sets a value that specifies the bookmark of the first record in the recordset to be cached. |
|
Marks the specified field in the current record as changed. |
|
Sets the value of the specified field in the current record to Null (having no value). |
|
Sets the value of a field in a recordset. |
|
Sets the value of a field in a recordset to Null. (having no value). |
|
Sets a value that indicates the type of locking to put into effect during editing. |
Overridables
Called to exchange data (in both directions) between the field data members of the recordset and the corresponding record on the data source. Implements DAO record field exchange (DFX). |
|
Returns the name of the default data source. |
|
Called to get the default SQL string to execute. |