What are the different cursor types that can we create
using ADO Recordset?
Difference between these cursor types?
- 2 Answers
- 8988 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 can you check whether a record is valid record or Invalid record using ADO control or Object?
Types of LockEdits in DAO? 51 .Types of Recordsets.
What is visual basic used for?
Types of LockEdits in RDO.
What is meant by Establish Connection in RDO?
what is the Difference between Linked Object and Embedded Object?
Explain about creating VB applications in excel?
What is the difference between change event in normal combobox and dbcombobox?
What is connection object in vb net?
by writing MACRO CODE,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). ex: custdetails custname lastname locaton mobile pincode custdetails raj tony hyd 555555 521245 servcreqrd srvce# srvcename location srvcepincode servcreqrd 754 drilling hyd 521784 for the above example in the another workbook retrive data like this custname Raj srvce# 754 srvcepincode 521784. while retrieving data control will search cell by cell for each row.
Give brief description about class?
What is the use of parameters collection?
What is the use of progress Bar Control?
What is the use of progress Bar Control?
Hi, I am USINg QTP tool for automation. Where VB Script have to use. I want to read a row from the table present in .Doc File and to paste in excel. Could you please assist me or give me the code to get it. I am new in this technology.
