Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

Can you create a tabletype of recordset in Jet connected ODBC dbengine.

1899


How would you attach pictures in Treeview Control?

1921


Explain about creating VB applications in excel?

1060


How can you get selected file from file system Control?

1948


What are the uses of List View Control?

1846


How come I get a "No Current Record" error when I use a a Data Control on an empty table?

1469


What do you mean by Databound Controls Explain?

1903


Which method is used to write context Into file?

1970


How would you access objects created in ActiveX Exe and ActiveX Dll

1955


what are the Differences between Recordset and Resultsets?

2463


What is Mask Edit and why it is used?

1834


How do you create a form in visual basic?

884


which property of menu cannot be set at run time.

1916


Explain about Caturing Baseline.

1068


Explain about ADO control?

951