Name the four different cursor and locking types in ADO ?
Answer / guest
CURSORS::
*********
The cursor types are listed from least to most resource
intensive.
Forward Only - Fastest, can only move forward in recordset
Static - Can move to any record in the recordset. Data is
static and never changes.
KeySet - Changes are detectable, records that are deleted
by other users are unavailable, and records created by
other users are not detected
Dynamic - All changes are visible.
LOCKING TYPES::
****************
LockPessimistic - Locks the row once after any edits occur.
LockOptimistic - Locks the row only when Update is called.
LockBatchOptimistic - Allows Batch Updates.
LockReadOnly - Read only. Cannot alter the data.
| Is This Answer Correct ? | 11 Yes | 0 No |
what are the Differences between Modal and Modaless forms?
What is Dataware Control?
How would you navigate between one document to another document in Internet Explorer ?
Difference Types of Procedures in VB?
How many types of API functions are available in VB?
How would you use ActiveX Dll and ActiveX Exe in your application?
How would you add column headers in listview control?
What is the difference between modal and modaless form in VB?
What does DoEvents do?
What is meant by Establish Connection in RDO? 74.1s it possible to Access BackEnd procedures? Explain.
what is the Benefit of wrapping database calls into MTS transactions?
How to down load image properties.
Visual Basic (800)
C Sharp (3816)
ASP.NET (3180)
VB.NET (461)
COM+ (79)
ADO.NET (717)
IIS (369)
MTS (11)
Crystal Reports (81)
BizTalk (89)
Dot Net (2435)
Exchange Server (362)
SharePoint (720)
WCF (340)
MS Office Microsoft (6963)
LINQ Language-Integrated Query (317)
WPF (371)
TypeScript (144)
Microsoft Related AllOther (311)