|
ADO Cursor Types by Phil Paxton (juggler@iquest.net)
ADO cursor types affects the properties and
methods that are available as this table illustrates.
| Property |
Forward-Only |
Dynamic |
Keyset |
Static |
| AbsolutePage |
N/A |
N/A |
R/W |
R/W |
| AbsolutePosition |
N/A |
N/A |
R/W |
R/W |
| ActiveConnection |
R/W |
R/W |
R/W |
R/W |
| BOF |
R/O |
R/O |
R/O |
R/O |
| Bookmark |
N/A |
N/A |
R/W |
R/W |
| CacheSize |
R/W |
R/W |
R/W |
R/W |
| CursorLocation |
R/W |
R/W |
R/W |
R/W |
| CursorType |
R/W |
R/W |
R/W |
R/W |
| EditMode |
R/O |
R/O |
R/O |
R/O |
| EOF |
R/O |
R/O |
R/O |
R/O |
| Filter |
R/W |
R/W |
R/W |
R/W |
| LockType |
R/W |
R/W |
R/W |
R/W |
| MarshalOptions |
R/W |
R/W |
R/W |
R/W |
| MaxRecords |
R/W |
R/W |
R/W |
R/W |
| PageCount |
N/A |
N/A |
R/O |
R/O |
| PageSize |
R/W |
R/W |
R/W |
R/W |
| RecordCount |
N/A |
N/A |
R/O |
R/O |
| Source |
R/W |
R/W |
R/W |
R/W |
| State |
R/O |
R/O |
R/O |
R/O |
| Status |
R/O |
R/O |
R/O |
R/O |
| Method |
|
|
|
|
| AddNew |
Yes |
Yes |
Yes |
Yes |
| CancelBatch |
Yes |
Yes |
Yes |
Yes |
| CancelUpdate |
Yes |
Yes |
Yes |
Yes |
| Clone |
N/A |
N/A |
Yes |
Yes |
| Close |
Yes |
Yes |
Yes |
Yes |
| Delete |
Yes |
Yes |
Yes |
Yes |
| GetRows |
Yes |
Yes |
Yes |
Yes |
| Move |
Yes |
Yes |
Yes |
Yes |
| MoveFirst |
Yes |
Yes |
Yes |
Yes |
| MoveLast |
N/A |
Yes |
Yes |
Yes |
| MoveNext |
Yes |
Yes |
Yes |
Yes |
| MovePrevious |
N/A |
Yes |
Yes |
Yes |
| NextRecordset |
Yes |
Yes |
Yes |
Yes |
| Open |
Yes |
Yes |
Yes |
Yes |
| Requery |
Yes |
Yes |
Yes |
Yes |
| Resync |
N/A |
N/A |
Yes |
Yes |
| Supports |
Yes |
Yes |
Yes |
Yes |
| Update |
Yes |
Yes |
Yes |
Yes |
| UpdateBatch |
Yes |
Yes |
Yes |
Yes |
Legend:
R/W = Read/Write
R/O = Read-Only
N/A = Not Available or Supported
Yes = Available/Supported
|