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 |