What are the different cursor types that can we create
using ADO Recordset?
Difference between these cursor types?
- 2 Answers
- 9170 Views
- I also Faced
- E-Mail Answers
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.
___ property used to add a menus at runtime.
How would you attach an ActiveX control in Your Application?
__ no of controls in form.
How would you run your ActiveX Document Dll?
I have several megabytes of memory. Why do I get an "out of memory" error?
How would you add column headers in listview control?
Why do I get "object not an array" when I try reference the fields of a global object variable which I have set to a table?
Explain Default cursor Type and LockEdit type in DAO?
___ argument can be used to make a menuitem into bold.
How would you create your application in DHTML?
What are the Internet tools available in VB 6.0?
Explain the working with task in Gantt chart view.
How do I get the Tab key to be treated like a normal character?
What is understand in resource tracking?
