A Cdbecordset object contains these collections, methods, and properties.
Legend:
|
Feature available in both Microsoft Jet and ODBCDirect workspaces. |
|
Feature available in Microsoft Jet workspaces only. |
|
Feature available in ODBCDirect workspaces only. |
Collections
| Fields (default) |
| Properties |
Methods
The following table lists all of the CdbRecordset methods, and shows which CdbRecordset type supports each method, and whether the method is available in either a Microsoft Jet or ODBCDirect workspace, or both.
| Method | Table | Dynaset | Snapshot | Forward-Only | Dynamic |
| AddNew | |
|
* |
|
|
| Cancel | |
|
|
|
|
| CancelUpdate | |
|
* |
|
|
| Clone | |
|
|
||
| Close | |
|
|
|
|
| CopyQueryDef | |
|
|
||
| Delete | |
|
* |
|
|
| Edit | |
|
* |
|
|
| FillCache | |
||||
| FindFirst | |
|
|||
| FindLast | |
|
|||
| FindNext | |
|
|||
| FindPrevious | |
|
|||
| GetField | |
|
|
|
|
| GetRows | |
|
|
|
|
| GetRowsEx | |
|
|
|
|
| Move | |
|
|
** | |
| MoveFirst | |
|
|
|
|
| MoveLast | |
|
|
|
|
| MoveNext | |
|
|
|
|
| MovePrevious | |
|
|
|
|
| NextRecordset | |
|
|
|
|
| OpenRecordset | |
|
|
||
| Requery | |
|
|
|
|
| Seek | |
||||
| SetField | |
|
|
|
|
| Update | |
|
* |
|
|
* In an ODBCDirect workspace, a snapshot-type CdbRecordset may be updatable, depending on the ODBC driver. The AddNew, Edit, Delete, Update, and CancelUpdate methods are only available on ODBCDirect snapshot-type CdbRecordset objects if the ODBC driver supports updatable snapshots.
** Used only with forward moves that don't use a bookmark offset.
Properties
The following table indicates which properties apply to each type of CdbRecordset object and whether the property setting is read/write, read-only, or always FALSE in either Microsoft Jet or ODBCDirect databases.
 |
Read-only |
 |
Read/write |
| Property | Table | Dynaset | Snapshot | Forward-Only | Dynamic |
| AbsolutePosition | |
|
|
||
| BatchCollisionCount | |
|
|
|
|
| BatchCollisions | |
|
|
|
|
| BatchSize | |
|
|
|
|
| BOF | |
|
|
|
|
| Bookmark | |
|
|
|
|
| Bookmarkable | |
|
|
|
|
| CacheSize | for Microsoft Jet workspaces |
|
|
||
| for ODBCDirect workspaces |
|||||
| CacheStart | |
||||
| Connection | |
|
|
|
|
| DateCreated | |
||||
| EditMode | |
|
|
|
|
| EOF | |
|
|
|
|
| Filter | |
|
|
||
| Index | |
||||
| LastModified | |
|
* |
|
|
| LastUpdated | |
||||
| LockEdits | |
for Microsoft Jet workspaces |
for Microsoft Jet workspaces |
|
|
| for ODBCDirect workspaces |
for ODBCDirect workspaces |
||||
| Name | |
|
|
|
|
| NoMatch | |
|
|
||
| PercentPosition | |
|
|
|
|
| RecordCount | |
|
|
|
|
| RecordStatus | |
|
|
|
|
| Restartable | False |
|
|
|
|
| Sort | |
|
|||
| StillExecuting | |
|
|
|
|
| Transactions | |
|
Always False |
Always False |
|
| Type | |
|
|
|
|
| Updatable | |
|
Always False in Microsoft Jet workspaces | Always False in Microsoft Jet workspaces | |
| in ODBCDirect workspaces * |
in ODBCDirect workspaces * |
||||
| UpdateOptions | |
|
|
|
|
| ValidationRule | |
|
|
|
|
| ValidationText | |
|
|
|
*In an ODBCDirect workspace, a snapshot-type CdbRecordset may be updatable, depending on the ODBC driver. The LastModified property is available and the Updatable property is True only on ODBCDirect snapshot-type CdbRecordset objects if the ODBC driver supports updatable snapshots.
Recordsets Collection
A Recordsets collection appears in each CdbConnection and CdbDatabase object and contains this method and this property.
Method
| Refresh |
Property
| Count |