The snapshot-type CdbRecordset object contains these collections, methods, and properties.
Legend:
|
Feature available in Microsoft Jet workspaces only. |
|
Feature available in ODBCDirect workspaces only. |
Collections
| Fields (default) |
| Properties |
| Methods | Restrictions | |
| AddNew | * |
|
| Cancel | |
|
| CancelUpdate | * |
|
| Clone | |
|
| Close | ||
| CopyQueryDef | |
|
| Delete | * |
|
| Edit | * |
|
| FindFirst | |
|
| FindLast | |
|
| FindNext | |
|
| FindPrevious | |
|
| GetRows | ||
| GetRowsEx | ||
| Move | ||
| MoveFirst | ||
| MoveLast | ||
| MoveNext | ||
| MovePrevious | ||
| NextRecordset | |
|
| OpenRecordset | |
|
| Requery | ||
| 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.
Properties
The following table indicates whether the property setting is read/write, read-only, or always FALSE in either Microsoft Jet or ODBCDirect workspaces.
Read-only
Read/write
| Properties | Restrictions |
| AbsolutePosition | |
| BatchCollisionCount | |
| BatchCollisions | |
| BatchSize | |
| BOF | |
| Bookmark | |
| Bookmarkable | |
| CacheSize | |
| Connection | |
| EditMode | |
| EOF | |
| Filter | |
| LastModified | * |
| LockEdits | |
|
|
| Name | |
| NoMatch | bmc ro.bmp} |
| PercentPosition | |
| RecordStatus | |
| Restartable | |
| Sort | |
| StillExecuting | bmc ro.bmp} |
| Transactions | Always FALSE |
| Type | |
| Updatable | Always FALSE in Microsoft Jet 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.