What are the different cursor types that can we create
using ADO Recordset?
Difference between these cursor types?
- 2 Answers
- 8768 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
how to use telugu language in vb6? any unicode data is available for telugu or not?yes means how to use? my desired output is telugu only? i am doing project like(telugu calendar),my output should be print in telugu only? pls send me the solution with code?
I'm getting error message "Reserved Error [-nnnn] ("There is no message for this error")" from Jet Engine 2.0.Why?
What is the current version of Visual Basic for Windows?
What is the difference between change event in normal combobox and dbcombobox?
i want to retrive data from one spead sheet to another UI (workbook). control will search cell by cell for each row and load the data in another workbook(UI).
What is the use of Scalewidth and ScaleHeight Proeperty?
Whether HTML supports multimedia: and document links?
Explain about declaring variables in Visual basic?
What is Pseudocode?
what are the Differences between Recordset and Resultsets?
How would you create Visual basic Document file?
What is the need of tabindex property is label control.
How would you access objects created in ActiveX Exe and ActiveX D1T ?
Explain about form creation in Visual Basic?
How to get freefile location in memory?
