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