vishnu bobade

• Sep 8th, 2005

 

Cursor type 
Dynamic ,Keyset ,Static ,Forward-only scrolling (this is the default)  
You work with a cursor through the DAO Recordset object. When you open a Recordset object through DAO, ODBCDirect creates the corresponding cursor. Each type of Recordset object, except for the table?type Recordset object, corresponds to a different type of cursor.  

vidyajnath

 Profile Answers by vidyajnath 

• Apr 8th, 2010

 

There are 4 different cursor types defined:

• Dynamic cursor - Allows you to see additions, changes, and deletions by other users.
  .
• Keyset cursor - Like a dynamic cursor, except that you cannot see additions by other users, and it prevents access to records that other users have deleted. Data changes by other users will still be visible.
  .
• Static cursor - Provides a static copy of a recordset for you to use to find data or generate reports. Additions, changes, or deletions by other users will not be visible. This is the only type of cursor allowed when you open a client-side Recordset object.
  .
• Forward-only cursor - Allows you to only scroll forward through the Recordset. Additions, changes, or deletions by other users will not be visible.