The following methods and properties are available from the Recordset object.
The Recordset object has the twenty-four methods shown in the following table. Twenty-one of these methods are available to developers using the OLE DB Provider for ODBC with D3 ODBC.
| Recordset Methods | Available |
|---|---|
| AddNew | Yes |
| Cancel | No |
| CancelBatch | Yes |
| CancelUpdate | Yes |
| Clone | Yes |
| Close | Yes |
| CompareBookmarks | Yes |
| Delete | Yes |
| Find | Yes |
| GetRows | Yes |
| GetString | Yes |
| Move | Yes |
| MoveFirst | Yes |
| MoveLast | Yes |
| MoveNext | Yes |
| MovePrevious | Yes |
| NextRecordset | Yes |
| Open | Yes |
| Requery | Yes |
| Resync | No |
| Save | Yes |
| Supports | Yes |
| Update | Yes |
| UpdateBatch | Yes |
The Recordset object has the twenty-two properties shown in the following table. Thirteen of these properties are available to developers using the OLE DB Provider for ODBC with D3 ODBC.
| Recordset Properties | Available |
|---|---|
| AbsolutePage | No |
| AbsolutePosition | No |
| ActiveConnection | Yes |
| BOF | Yes |
| Bookmark | Yes |
| CacheSize | Yes |
| CusorLocation | Yes* |
| CursorType | Yes** |
| EditMode | Yes |
| EOF | Yes |
| Filter | Yes |
| LockType | Yes*** |
| MarshalOptions | No |
| MaxRecords | No |
| PageCount | No |
| PageSize | No |
| RecordCount | No |
| Sort | No |
| Source | Yes |
| State | Yes**** |
| Status | Yes |
| StayInSync | No |
*Available options – adUseServer, adUseClient
**Available options – adOpenForwardOnly, adOpenStatic
***Available options – adLockReadOnly, adLockOptimistic, adLockBatchOptimistic
****Available options – adStateOpen, adStateClosed