Supports Method
Determines whether a specified Recordset
object supports a particular type of functionality.
Syntax
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.
|
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.
Applies To
Recordset
See Also
CursorType
| 
