Determines whether a specified Recordset object supports a particular type of functionality.
Syntax
boolean = recordset.Supports( CursorOptions )
Return Value
Returns a Boolean value that indicates whether all of the features identified by the CursorOptions argument are supported by the provider.
Parameters
CursorOptions A Long expression that consists of one or more of the following CursorOptionEnum values.
| Constant | Description |
| adAddNew | You can use the AddNew method to add new records. |
| adApproxPosition | You can read and set the AbsolutePosition and AbsolutePage properties. |
| adBookmark | You can use the Bookmark property to gain access to specific records. |
| adDelete | You can use the Delete method to delete records. |
| adHoldRecords | You can retrieve more records or change the next retrieve position without committing all pending changes. |
| adMovePrevious | You can use the MoveFirst and MovePrevious methods, and Move or GetRows methods to move the current record position backward without requiring bookmarks. |
| adResync | You can update the cursor with the data visible in the underlying database, using the Resync method. |
| adUpdate | You can use the Update method to modify existing data. |
| adUpdateBatch | You can use batch updating (UpdateBatch and CancelBatch methods) to transmit changes to the provider in groups. |
Remarks
Use the Supports method to determine what types of functionality a Recordset object supports. If the Recordset object supports the features whose corresponding constants are in CursorOptions, the Supports method returns True. Otherwise, it returns False.
Note Although the Supports method may return True for a given functionality, it does not guarantee that the provider can make the feature available under all circumstances. The Supports method simply returns whether or not the provider can support the specified functionality, assuming certain conditions are met. For example, the Supports method may indicate that a Recordset object supports updates even though the cursor is based on a multitable join, some columns of which are not updatable.