Supports

This method determines whether a specified Recordset object supports a particular type of functionality.

Syntax

Boolean = recordset.Supports(CursorOptions)

Parameters

CursorOptions

Long expression. The Long expression is one of the values, or a combination of the values, described in the following table.

Constant	Value	Description
adAddNew	16778240	Supports the AddNew method.
adApproxPosition	16384	Supports the AbsolutePosition and AbsolutePage properties.
adBookmark	8192	Supports the Bookmark property.
adDelete	16779264	Supports the Delete method.
adMovePrevious	512	Supports the MovePrevious and Move methods to move the current record position backward.
adUpdate	16809984	Supports the Update method.
adHoldRecords	256	Not supported in ADOCE.
adResync	131072	Not supported in ADOCE.
adUpdateBatch	65536	Not supported in ADOCE.

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.

ADOCE always returns False for any of the following constants: adHoldRecords, adResync and adUpdateBatch. All other constants can return True.

Example

The following code example sets the constants for the Supports method.

Const adHoldRecords = &H00000100
Const adMovePrevious = &H00000200
Const adAddNew = &H01000400
Const adDelete = &H01000800
Const adUpdate = &H01008000
Const adBookmark = &H00002000
Const adApproxPosition = &H00004000
Const adUpdateBatch = &H00010000
Const adResync = &H00020000
Const adNotify = &H00040000