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