What are the different cursor types that can we create
using ADO Recordset?
Difference between these cursor types?
Answer Posted / pratik
•A Static Cursor doesn't reflect data changes made to the DB once the ResultSet has been created whereas a Dynamic Cursor reflects the changes as and when they happen.
•A Static Cursor is much more performant than a Dynamic Cursor as it doesn't require further interaction with the DB server.
•A static cursor supports both Relative and Absolute Positioning whereas a Dynamic Cursor supports only Relative Positioning.
•A Static Cursor can be used for Bookmarking purposes as the data returned is static whereas a Dynamic Cursor can't be used for the same
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Types of LockEdits in DAO? 51 .Types of Recordsets.
What is connection object in vb net?
How do I play MID, WAV or other multimedia files?
When/Why should I use Option Explicit?
which property used to add a menus at runtime?
Types of Resultsets.
How about Access 2.0 compatibility?
what is the Difference between Linked Object and Embedded Object?
Explain the types of Views in Listview Control.
Difference between Tabletype and Snapshot?
What is OLEDB?
Explain about an event-driven programming language?
What is Pseudocode?
what is the Difference between Recordset and Querydef?
Give brief description about class?