The Recordset Object | |
A Recordset object represents the entire set of records from a base table or the results of an executed command. At any time, the Recordset object only refers to a single record within the set as the current record. |
AddNew | |
Method | |
Creates a new record for an updateable Recordset object. |
Cancel | |
Method | |
Cancels execution of a pending asynchronous Open operation. |
CancelBatch | |
Method | |
Cancels a pending batch update. |
CancelUpdate | |
Method | |
Cancels any changes made to the current record, or to a new record prior to calling the Update method. |
Clone | |
Returns: Recordset | Method |
Creates a duplicate Recordset object from and existing Recordset object. |
Close | |
Method | |
Closes the Recordset object and any dependent objects. |
CompareBookmarks | |
Returns: Compare Enum | Method |
Compares two bookmarks and returns an indication of the relative values. |
Delete | |
Method | |
Deletes the current record or group of records. |
Find | |
Method | |
Searches the Recordset for a record that matches the specified criteria. |
GetRows | |
Returns: Variant | Method |
Retrieves multiple records of a Recordset object into an array. |
GetString | |
Returns: String | Method |
Returns a Recordset as a string. |
Move | |
Method | |
Moves the recordset cursor to point at a Recordset. |
MoveFirst | |
Method | |
Moves the recordset cursor to point at the first record in the Recordset. |
MoveLast | |
Method | |
Moves the recordset cursor to point at the last record in the Recordset. |
MoveNext | |
Method | |
Moves the recordset cursor to point at the next record in the Recordset. |
MovePrevious | |
Method | |
Moves the recordset cursor to point at the previous record in the Recordset. |
NextRecordset | |
Returns: Recordset | Method |
Clears the current Recordset object and returns the next Recordset by advancing through a series of commands. |
Open | |
Method | |
Opens a Recordset. |
Requery | |
Method | |
Updates the data in a Recordset object by re-executing the query on which the object is based. |
Resync | |
Method | |
Refreshes the data in the current Recordset object from the underlying database. |
Save | |
Method | |
Saves the Recordset to a file. |
Seek | |
Method | |
Searches the recordset index to locate a value |
Supports | |
Returns: Boolean | Method |
Determines whether a specified Recordset object supports particular functionality. |
Update | |
Method | |
Saves any changes made to the current Recordset object. |
UpdateBatch | |
Method | |
Writes all pending batch updates to disk. |
AbsolutePage | |
Returns: PositionEnum | Property |
Specifies in which page the current record resides. |
AbsolutePosition | |
Returns: PositionEnum | Property |
Specifies the ordinal position of a Recordset object's current record. |
ActiveCommand | |
Returns: Object | Property |
Indicates the Command object that created the associated Recordset object. Read only. |
ActiveConnection | |
Returns: Variant | Property |
Indicates to which Connection object the specified Recordset object currently belongs. |
BOF | |
Returns: Boolean | Property |
Indicates whether the current record is before the first record in a Recordset object. Read only. |
Bookmark | |
Returns: Variant | Property |
Returns a bookmark that uniquely identifies the current record in a Recordset object, or sets the current record to the record identified by a valid bookmark. |
CacheSize | |
Returns: Long | Property |
Indicates the number of records from a Recordset object that are cached locally in memory. |
CursorLocation | |
Returns: CursorLocation Enum | Property |
Sets or returns the location of the cursor engine. |
CursorType | |
Returns: CursorType Enum | Property |
Indicates the type of cursor used in a Recordset object. |
DataMember | |
Returns: String | Property |
Specifies the name of the data member to retrieve from the object referenced by the DataSource property. Write only. |
DataSource | |
Returns: Object | Property |
Specifies an object containing data to be represented as a Recordset object. Write only. |
EditMode | |
Returns: EditModeEnum | Property |
Indicates the editing status of the current record. Read only. |
EOF | |
Returns: Boolean | Property |
Indicates whether the current record is after the last record in a Recordset object. Read only. |
Fields | |
Returns: Fields | Property |
Contains all of the Field objects for the current Recordset object. |
Filter | |
Returns: Variant | Property |
Indicates a filter for data in the Recordset. |
Index | |
Returns: String | Property |
Identifies the name of the index currently being used. |
LockType | |
Returns: LockTypeEnum | Property |
Indicates the type of locks placed on records during editing. |
MarshalOptions | |
Returns: MarshalOptions Enum | Property |
Indicates which records are to be marshaled back to the server. |
MaxRecords | |
Returns: Long | Property |
Indicates the maximum number of records to return to a Recordset object from a query. Default is zero (no limit). |
PageCount | |
Returns: Long | Property |
Indicates how many pages of data the Recordset object contains. Read only. |
PageSize | |
Returns: Long | Property |
Indicates how many records constitute one page in the Recordset. |
Properties | |
Returns: Properties | Property |
Contains all of the Property objects for the current Recordset object. |
RecordCount | |
Returns: Long | Property |
Indicates the current number of records in the Recordset object. Read only. |
Sort | |
Returns: String | Property |
Specifies one or more field names the Recordset is sorted on, and the direction of the sort. |
Source | |
Returns: String | Property |
Indicates the source for the data in a Recordset object. |
State | |
Returns: Long | Property |
Indicates whether the recordset is open, closed, or whether it is executing an asynchronous operation. Read only. |
Status | |
Returns: Integer | Property |
Indicates the status of the current record with respect to match updates or other bulk operations. Read only. |
StayInSync | |
Returns: Boolean | Property |
Indicates, in a hierarchical Recordset object, whether the parent row should change when the set of underlying child records changes. Read only. |
EndOfRecordset | |
Event | |
Fired when there is an attempt to move to a row past the end of the Recordset. |
FetchComplete | |
Event | |
Fired after all the records in an asynchronous operation have been retrieved into the Recordset. |
FetchProgress | |
Event | |
Fired periodically during a lengthy asynchronous operation, to report how many rows have currently been retrieved. |
FieldChangeComplete | |
Event | |
Fired after the value of one or more Field objects have been changed. |
MoveComplete | |
Event | |
Fired after the current position in the Recordset changes. |
RecordChangeComplete | |
Event | |
Fired after one or more records change. |
RecordsetChangeComplete | |
Event | |
Fired after the Recordset has changed. |
WillChangeField | |
Event | |
Fired before a pending operation changes the value of one or more Field objects. |
WillChangeRecord | |
Event | |
Fired before one or more rows in the Recordset change. |
WillChangeRecordset | |
Event | |
Fired before a pending operation changes the Recordset. |
WillMove | |
Event | |
Fired before a pending operation changes the current position in the Recordset. |