471,881 Members | 1,321 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes and contribute your articles to a community of 471,881 developers and data experts.

Meet the ADO Cursors

8,827 Expert 8TB
A Cursor, in ADO, is the underlying Object that makes it possible to move around within the set of rows returned by a Recordset. The Cursor manages movement, updatability, and currency of the rows you've requested. DAO has 3 simple Cursor Types: Table, Dynaset, and Snapshot. ADO's Cursor options are a bit more flexible and are more complex. ADO contains 4 types of ADO Recordset Cursors. The one you should select depends on the source of the data being referenced, and the methods you need to use to access the data. Without any further delay, let me introduce the ADO Cursors along with their benefits and drawbacks:
  1. Dynamic (adOpenDynamic) - A set of Records in a Table or other data source in a Database. This Cursor shows all Record changes by other users including new. It allows Bookmarks only if the provider supports them. It is not supported by the Jet OLE DB provider in this manner. Jet uses this Cursor Type to provide best performance for Cursors based on SQL strings.
  2. Keyset (adOpenKeyset) - It is a set of pointers (bookmarks) referring to data in Tables or Queries in a Database. This Cursor shows changes by other users and always supports Bookmarks. It does not show new Records by other users, and also prevent access to Records deleted by other users.
  3. Static (adOpenStatic) - It is a copy of a set of records as it exists at the time the Recordset is created. This Cursor always supports Bookmarks. It is the only type of Recordset allowed by a Client-side Cursor. It does not reflect changes to data made in a multi-user environment.
  4. Forward-Only (adOpenForwardOnly) [DEFAULT] - It is a copy of a set of Records as it exists at the time the Recordset is created. This Cursor is faster than a Static Cursor. A Forward-only Cursor only allows forward scrolling through Recordsets.
Jun 12 '07 #1
0 6337

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

11 posts views Thread by Alban Hertroys | last post: by
22 posts views Thread by T.S.Negi | last post: by
5 posts views Thread by Todd Huish | last post: by
6 posts views Thread by a | last post: by
5 posts views Thread by Boni | last post: by
7 posts views Thread by H. Williams | last post: by
1 post views Thread by Dima Kuchin | last post: by
reply views Thread by YellowAndGreen | last post: by
reply views Thread by zermasroor | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.