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
What is snapshot in vb?
How can I change the printer Windows uses in code without using the print common dialog? How can I change orientation?
Explain about an event-driven programming language?
What do you mean by Databound Controls Explain?
Why visual basic is used?
Is visual basic still used?
How do I make my applications screen-resolution independent?
What is the use of ActiveX Documents?
Does VB support pointers to functions?
Is there any Edit method in ADO Data Access method?
What is ActiveX Dll and ActiveX Exe?
what are the types of cursors in DAO?
Maximum Control Names length?
To find the current recordposition in data control.
How would you use ActiveX Dll and ActiveX Exe in your application?