Snapshot-Type CdbRecordset Object Summary

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.