ADO Supports Method
The Supports method returns a Boolean value that indicates
whether or not the specified functionality will be supported by the
Recordset object. A return of True means that the
functionality is supported. While False means that the
functionality is not supported.
The Recordset object that you have opened, and the provider that
you are working with, simply may not support using all of the various
events, methods, and properties that are potentially available to the
Recordset object. Further, even if a True is returned by this
method, the provider still may not support the functionality under all
possible circumstances.
There is one mandatory parameter.
Syntax
objRecordset.Supports(cursoroptions)
|
| Parameter |
Description |
cursoroptions
|
Required. One or more CursorOptionEnum values
that specifies what functionality this method should test for |
Examples
If objRecordset.Supports(adIndex)
Then
objRecordset.Index = "addressIndex"
End If
CursorOptionEnum
| Constant |
Value |
Description |
| adHoldRecords |
0x100 |
Retrieves more records or changes
the next position without committing all pending changes |
| adMovePrevious |
0x200 |
Supports the MoveFirst and
MovePrevious methods, and Move or GetRows methods |
| adBookmark |
0x2000 |
Supports the Bookmark property |
| adApproxPosition |
0x4000 |
Supports the AbsolutePosition and
AbsolutePage properties |
| adUpdateBatch |
0x10000 |
Supports UpdateBatch and
CancelBatch methods |
| adResync |
0x20000 |
Supports the Resync method |
| adNotify |
0x40000 |
Indicates that the data provider
supports notifications (which determines whether Recordset
events are supported) |
| adFind |
0x80000 |
Supports the Find method |
| adIndex |
0x100000 |
Supports the Index property |
| adSeek |
0x200000 |
Supports the Seek method |
| adAddNew |
0x1000400 |
Supports the AddNew method |
| adDelete |
0x1000800 |
Supports the Delete method |
| adUpdate |
0x1008000 |
Supports the Update method |
|