Determines whether a specified Recordset object supports a particular type of functionality.
Set boolean = recordset.Supports(CursorOptions)
The Supports method syntax has these parts:
|
Part |
Description |
|
boolean |
A Boolean variable that indicates whether the specified functionality is available. |
|
recordset |
An object variable representing an open Recordset object. |
|
CursorOptions |
A Long expression that consists of one or more of the constants listed under 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.
The CursorOptions argument can be set to any one or a sum of the following CursorOptionEnum values:
|
Constant |
Value |
Functionality |
|
adAddNew |
16778240 |
You can use the AddNew method to add new records. |
|
adApproxPosition |
16384 |
You can read and set the AbsolutePosition and AbsolutePage properties. |
|
adBookmark |
8192 |
You can use the Bookmark property to access specific records. |
|
adDelete |
16779264 |
You can use the Delete method to delete records. |
|
adHoldRecords |
256 |
You can retrieve more records or change the next retrieve position without committing all pending changes and releasing all currently held records. |
|
adMovePrevious |
512 |
You can use the MovePrevious or Move methods to move the current record position backward without requiring bookmarks. |
|
adResync |
131072 |
You can update the cursor with the data visible in the underlying database. |
|
adUpdate |
16809984 |
You can use the Update method to modify existing data. |
|
adUpdateBatch |
65536 |
You can use batch updating to transmit changes to the provider in groups. |
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 multi-table join, some of the columns of which are not updatable.