This method determines if the recordset supports certain features.
Syntax
Boolean = recordset.Supports(CursorOptions)
Parameters
CursorOptions
Long expression. The Long expression is one of the values, or a combination of the values, described in the following table.
| Constant | Value | Description |
| adAddNew | 16778240 | Supports the AddNew method. |
| adApproxPosition | 16384 | Supports the AbsolutePosition and AbsolutePage properties. |
| adBookmark | 8192 | Supports the Bookmark property. |
| adDelete | 16779264 | Supports the Delete method. |
| adMovePrevious | 512 | Supports the MovePrevious and Move methods to move the current record position backward. |
| adUpdate | 16809984 | Supports the Update method. |
| adHoldRecords | 256 | Not supported in ADOCE. |
| adResync | 131072 | Not supported in ADOCE. |
| adUpdateBatch | 65536 | Not supported in ADOCE. |
Remarks
Use the Supports method to determine what types of functionality a Recordset object supports. If a Recordset object supports the features whose corresponding constants are in CursorOptions, the Supports method returns True. Otherwise, it returns False.
ADOCE always returns False for any of the following constants: adHoldRecords, adResync, and adUpdateBatch. All other constants can return True.
Example
The following code example sets the constants for the Supports method.
Const adHoldRecords = &H00000100
Const adMovePrevious = &H00000200
Const adAddNew = &H01000400
Const adDelete = &H01000800
Const adUpdate = &H01008000
Const adBookmark = &H00002000
Const adApproxPosition = &H00004000
Const adUpdateBatch = &H00010000
Const adResync = &H00020000
Const adNotify = &H00040000