Supports Method (ADO)


		Contents Index Topic Contents

Supports Method - ADO

Determines whether a specified Recordset object supports a particular type of functionality.
Applies To
Recordset
Syntax
boolean = recordset.Supports( CursorOptions )
Return Values
Returns a Boolean value that indicates whether all of the features identified by the CursorOptions argument are supported by the provider.
Parameters
CursorOptions A Long expression that consists of one or more of the following CursorOptionEnum values:

adAddNew You can use the AddNew method to add new records.

adApproxPosition You can read and set the AbsolutePosition and AbsolutePage properties.

adBookmark You can use the Bookmark property to access specific records.

adDelete You can use the Delete method to delete records.

adHoldRecords You can retrieve more records or change the next retrieve position without committing all pending changes.

adMovePrevious You can use the MoveFirst and MovePrevious methods, and Move or GetRows methods to move the current record position backward without requiring bookmarks.

adResync You can update the cursor with the data visible in the underlying database, using the Resync method.

adUpdate You can use the Update method to modify existing data.

adUpdateBatch You can use batch updating (UpdateBatch and CancelBatch methods) to transmit changes to the provider in groups.

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.
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 columns of which are not updatable.
Examples
Supports Method Example (VB)

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

adAddNew	You can use the AddNew method to add new records.
adApproxPosition	You can read and set the AbsolutePosition and AbsolutePage properties.
adBookmark	You can use the Bookmark property to access specific records.
adDelete	You can use the Delete method to delete records.
adHoldRecords	You can retrieve more records or change the next retrieve position without committing all pending changes.
adMovePrevious	You can use the MoveFirst and MovePrevious methods, and Move or GetRows methods to move the current record position backward without requiring bookmarks.
adResync	You can update the cursor with the data visible in the underlying database, using the Resync method.
adUpdate	You can use the Update method to modify existing data.
adUpdateBatch	You can use batch updating (UpdateBatch and CancelBatch methods) to transmit changes to the provider in groups.