Supports Method - ADO

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

Applies To

Recordset

Required Files

msado15.dll
VC: adoint.h, adoid.h

Syntax

boolean = recordset.Supports(CursorOptions)

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.

Examples

Supports Method Example (VB)

© 1997 Microsoft Corporation. All rights reserved. Terms of Use.