METHOD:  Recordset::Supports
Boolean = recordsetobject.Supports (CursorOptions)

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.

The CursorOptions parameter is a long expression that is composed of one or more CursorOptionEnum constants. There is no default value. These values can be joined together in this parameter using a Boolean logic operator such as an OR.

CursorOptionEnum Constants
 
Constant Value Description
adAddNew 0x1000400 Supports AddNew method
adApproxPosition 0x4000 Supports AbsolutePosition and AbsolutePage properties
adBookmark 0x2000 Supports Bookmark property
adDelete 0x1000800 Supports Delete method
adFind 0x80000 Supports Find method
adHoldRecords 0x100 Supports retrieving more records or changing the position without having to save pending changes
adIndex 0x100000 Supports Index property
adMovePrevious 0x200 Supports GetRows, Move, MoveFirst, and MoveLast methods
adNotify 0x40000 Supports events
adResync 0x20000 Supports Resync method
adSeek 0x200000 Supports Seek method
adUpdate 0x1008000 Supports Update method
adUpdateBatch 0x10000 Supports UpdateBatch and CancelBatch methods

 
Code (VBScript):
If objRecordset.Supports(adIndex) Then
   objRecordset.Index = "addressIndex"
End If
Copyright 1999-2001 by Infinite Software Solutions, Inc. All rights reserved.
Trademark Information