W3Schools

home HOME

ADO Tutorial
ADO HOME
ADO Intro
ADO Connect
ADO Recordset
ADO Display
ADO Query
ADO Sort
ADO Add
ADO Update
ADO Delete
ADO Demo
ADO Speed Up

ADO Objects
ADO Command
ADO Connection
ADO Error
ADO Field
ADO Parameter
ADO Property
ADO Record
ADO Recordset
ADO Stream
ADO DataTypes

ADO Summary

Examples
ADO Examples

Exam
ADO Exam

Selected Reading
Web Statistics
Web Glossary
Web Hosting
Web Quality

W3Schools Forum

Helping W3Schools

ADO Supports Method

Recordset Object Reference Complete Recordset Object Reference

The Supports method returns a boolean value that defines whether or not a Recordset object supports a specific type of functionality. 

Note: This method returns true if the specified feature is supported, false if not.

Syntax 

objRecordset.Supports(cursoroptions)

Parameter Description
cursoroptions Required. One or more CursorOptionEnum values that specifies what functionality this method should test for

CursorOptionEnum
Constant Value Description
adHoldRecords 0x100 Retrieves more records or changes the next position without committing all pending changes
adMovePrevious 0x200 Supports the MoveFirst and MovePrevious methods, and Move or GetRows methods
adBookmark 0x2000 Supports the Bookmark property
adApproxPosition 0x4000 Supports the AbsolutePosition and AbsolutePage properties
adUpdateBatch 0x10000 Supports UpdateBatch and CancelBatch methods
adResync 0x20000 Supports the Resync method
adNotify 0x40000 Indicates that the data provider supports notifications (which determines whether Recordset events are supported)
adFind 0x80000 Supports the Find method
adIndex 0x100000 Supports the Index property
adSeek 0x200000 Supports the Seek method
adAddNew 0x1000400 Supports the AddNew method
adDelete 0x1000800 Supports the Delete method
adUpdate 0x1008000 Supports the Update method

Recordset Object Reference Complete Recordset Object Reference
diploma   

Get Your Diploma!

W3Schools' Online Certification Program is the perfect solution for busy professionals who need to balance work, family, and career building.

The HTML Certificate is for developers who want to document their knowledge of HTML, XHTML, and CSS.

The ASP Certificate is for developers who want to document their knowledge of ASP, SQL, and ADO.

Jump to: Top of Page or HOME or Printer Friendly Printer friendly page

W3Schools provides material for training only. We do not warrant the correctness of its contents. The risk from using it lies entirely with the user. While using this site, you agree to have read and accepted our terms of use and privacy policy.

Copyright 1999-2008 by Refsnes Data. All Rights Reserved.

Validate Validate W3C-WAI level A conformance icon W3Schools was converted to XHTML in December 1999