Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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. |