Supports Method

Determines whether a specified Recordset object supports a particular type of functionality.

Syntax

Set boolean = recordset.Supports(CursorOptions)

The Supports method syntax has these parts:

Part	Description
boolean	A Boolean variable that indicates whether the specified functionality is available.
recordset	An object variable representing an open Recordset object.
*CursorOptions*	A Long expression that consists of one or more of the constants listed under Remarks.

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.

The CursorOptions argument can be set to any one or a sum of the following CursorOptionEnum values:

Constant	Value	Functionality
adAddNew	16778240	You can use the AddNew method to add new records.
adApproxPosition	16384	You can read and set the AbsolutePosition and AbsolutePage properties.
adBookmark	8192	You can use the Bookmark property to access specific records.
adDelete	16779264	You can use the Delete method to delete records.
adHoldRecords	256	You can retrieve more records or change the next retrieve position without committing all pending changes and releasing all currently held records.
adMovePrevious	512	You can use the MovePrevious or Move methods to move the current record position backward without requiring bookmarks.
adResync	131072	You can update the cursor with the data visible in the underlying database.
adUpdate	16809984	You can use the Update method to modify existing data.
adUpdateBatch	65536	You can use batch updating to transmit changes to the provider in groups.

Note Although the Supports method may return True for a given functionality, it does not guarantee that the provider can make the feature available under all circumstances. The Supports method simply returns whether or not the provider can support the specified functionality assuming certain conditions are met. For example, the Supports method may indicate that a Recordset object supports updates even though the cursor is based on a multi-table join, some of the columns of which are not updatable.

Applies To

Recordset

Supports Method

Syntax

Remarks

Applies To

See Also