لطفا منتظر باشید ...
Recordset
Methods
Name | Returns | Description |
|---|---|---|
AddNew | Creates a new record in the Recordset . | |
Cancel | Cancels execution of an asynchronous Execute, OpenRecordset , or OpenConnection . | |
CancelUpdate | Cancels any pending Update statements. | |
Clone | Recordset | Creates a duplicate Recordset . |
Close | Closes an open DAO object. | |
CopyQueryDef | QueryDef | Returns a copy of the QueryDef that created the Recordset . |
Delete | Deletes a record from a Recordset . | |
Edit | Prepares a row of a Recordset for editing. | |
FillCache | Fills the cache for an ODBC-derived Recordset . | |
FindFirst | Locates the first record that satisfies the criteria. | |
FindLast | Locates the last record that satisfies the criteria. | |
FindNext | Locates the next record that satisfies the criteria. | |
FindPrevious | Locates the previous record that satisfies the criteria. | |
GetRows | Variant | Retrieves multiple records of a Recordset into an array. |
Move | Moves the position of the current record in a Recordset . | |
MoveFirst | Moves to the first record in the Recordset . | |
MoveLast | Moves to the last record in the Recordset . | |
MoveNext | Moves to the next record in the Recordset . | |
MovePrevious | Moves to the previous record in the Recordset . | |
NextRecordset | Boolean | Fetches next recordset in a multi-query Recordset |
OpenRecordset | Recordset | Creates a new Recordset object. |
Requery | Re-executes the query the Recordset is based on. | |
Seek | Locates a record in a table-type Recordset . | |
Update | Saves changes made with the Edit or AddNew methods. |
Properties
Name | Returns | Description |
|---|---|---|
AbsolutePosition | Long | Sets or returns the relative record number of the current record. |
BatchCollisionCount | Indicates how many rows had collisions in the last batch update. Read-only. | |
BatchCollisions | Variant | Indicates which rows had collisions in the last batch update. Read-only. |
BatchSize | Long | Determines how many updates to include in a batch. |
BOF | Boolean | Indicates whether the current record position is before the first record. Read-only. |
Bookmark | Uniquely identifies a particular record in a Recordset . | |
Bookmarkable | Boolean | Indicates whether a Recordset supports bookmark. Read-only. |
CacheSize | Long | Sets or returns the number of records to be locally cached from an ODBC data source. |
CacheStart | Sets or returns the bookmark of the first record to be cached from an ODBC data source. | |
Connection | Connection | Indicates which Connection owns the Recordset . |
DateCreated | Variant | Returns the date and time when the underlying base table was created. Read-only. |
EditMode | Integer | Returns the state of editing for the current record. Read-only. |
EOF | Boolean | Indicates whether the current record position is after the last record. Read-only. |
Fields | Fields | Collection of Field objects in a Recordset object. Read-only. |
Filter | String | Sets or returns a value indicating a filter to apply to a Recordset . |
Index | String | Sets or returns the name of the current Index object (table-type Recordset only). |
LastModified | Returns a bookmark indicating the most recently added or changed record. Read-only. | |
LastUpdated | Variant | Returns the date and time of the most recent change to an object. Read-only. |
LockEdits | Boolean | Returns the type of locking in effect during editing. |
Name | String | Returns the name of this object. Read-only. |
NoMatch | Boolean | Indicates whether a record was found with the Seek or Find method. Read-only. |
PercentPosition | Single | Sets or returns the approximate location of the current record. |
Properties | Properties | Collection of Property objects. Read-only. |
RecordCount | Long | Returns the number of records accessed in a Recordset . Read-only. |
RecordStatus | Integer | Indicating the batch-update status of the current record. Read-only. |
Restartable | Boolean | Indicates whether a Recordset object supports the Requery method. Read-only. |
Sort | String | Sets or returns the sort order for records in a Recordset . |
StillExecuting | Boolean | Indicates whether an asynchronous method call is still executing. Read-only. |
Transactions | Boolean | Indicates whether the Recordset object supports transaction. Read-only. |
Type | Integer | Returns the data type of an object. Read-only. |
Updatable | Boolean | Returns whether records in the Recordset can be update. Read-only. |
UpdateOptions | Long | Determines how a batch update query will be constructed. |
ValidationRule | String | Sets or returns a value indicating whether a field contains valid data. Read-only. |
ValidationText | String | Sets or returns a value indicating a message if an entered value is invalid. Read-only. |
