Skip to Content
ADO: ActiveX Data Objects
book

ADO: ActiveX Data Objects

by Jason T Roff
June 2001
Intermediate to advanced
620 pages
19h 29m
English
O'Reilly Media, Inc.
Content preview from ADO: ActiveX Data Objects

Name

Recordset.CursorType Property — (Versions 2.0, 2.1, 2.5, 2.6)

Synopsis

                     recordset.CursorLocation = cursorlocation
                  

The CursorType property indicates the type of cursor to be used for the current recordset.

Datatype

CursorTypeEnum (Long)

Description

The CursorType property indicates the type of cursor that should be used when the Recordset object is opened. The value of this property is read- and write-enabled when the Recordset object is closed and read-only when it is opened. The value of the CursorType property can be one of the CursorType enumerations listed in Appendix E.

If the current data provider does not support the selected cursor type, the value of the CursorType property changes when the Recordset object is opened. This value can be read by the application if need be. In this case, once the Recordset object is closed, the original selected value will be returned to the CursorType property.

You can use the Supports method of the Recordset object to see what functionality is supported by the chosen cursor type. (See Chapter 5 for more information on cursor types.)

The Dynamic cursor supports the adMovePrevious functionality as described by the Supports method. The Forward Only cursor does not support any of the functionality that the Supports method indicates. The Keyset cursor and the Static cursor support adBookmark, adHoldRecords, adMovePrevious, and adResync functionality as described by the Supports method.

The Forward Only cursor type does not support bookmarks, because ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

AirBnbBlueOriginElectronic ArtsHomeDepotNasdaqRakutenTata Consultancy Services

QuotationMarkO’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.
Julian F.
Head of Cybersecurity
QuotationMarkI wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.
Addison B.
Field Engineer
QuotationMarkI’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.
Amir M.
Data Platform Tech Lead
QuotationMarkI'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Mark W.
Embedded Software Engineer

You might also like

Database Internals

Database Internals

Alex Petrov

Publisher Resources

ISBN: 1565924150Errata Page