DevGuru ADO Recordset::Supports Method

Quick References

Features

Partners

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