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


Please Help Members By Posting Answers For Below Questions

which property of menu cannot be set at run time.

1728


What is the-use of property page Wizard in ActiveX Control?

1782


Is it possible to Access BackEnd procedures? Explain.

1793


What is the use of ActiveX Documents?

2220


Write the Steps in Creating an ActiveX Control?

2257


How would you add column headers in listview control?

1895


Give brief description about class?

1689


Types of LockEdits in RDO.

1915


How can you save and Get data from Clipboard/ Recordset object consists what?

799


Why does everybody say I should save in TEXT not BINARY?

1389


Explain about the basic features of Visual basic?

809


Difference between DDE and OLE.

3055


Types of cursors in DAO?

1747


What is ado in vb.net?

775


How would you add elements and pictures to listitems in listview control?

1833