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

Explain about form creation in Visual Basic?

1214


how a multiple routing works ?

2795


When/Why should I use Option Explicit?

1419


What are the types of line styles available in Treeview Control?

1843


VB ActiveX: Create a "drivelist"(D1) box, a "folderlistbox"(FLD1) that changes whenever D1 is changed , and a "FilelistBox"(FIL1) that is populated with the file lists under the selected directory in (D1).The file selected is stored in a variable "filename" along with the path. Question: How to use this activeX control in VC++ to get the selected filename?

2001


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

1959


What are the tools available for Debuggiu in VB?

1924


What is ActiveX Control?

2170


What are forms in visual basic?

995


what are the Types of Resultsets?

2490


How would you create your application in DHTML?

1838


Is visualvm free?

1044


What are the uses of List View Control?

1937


How to customize workgroup message?

988


___ property is used to change to ___ value to access a identity column'in datacontrols.

1559