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
How many objects resides in ADO ?
How would you add elements in TreevieW Control?
How do I do Peek and Poke and other low-level stuff?
How would you attach pictures in column headers of List View Control?
Can you create a updatecascade, Deletecascade relation in Ms- Access? If no, give on eample.
How do I set the Windows wallpaper at runtime?
Explain about creating VB applications in excel?
How do you change the icon and otherwise manipulate the DOS box?
How can you filter out specific type of file using file system controls?
What is controls in vb?
It is possible to access Text (x.txt) files? Explain.
Are there any examples of commercial applications built using Visual Basic?
Can a VB application be an OLE server?
Explain about the basic features of Visual basic?
Is it possible to Access BackEnd procedures? Explain.