CdbRecordset Object Summary

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