Name the four different cursor and locking types in ADO ?
Answer Posted / 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 |
Post New Answer View All Answers
What is the use of progress Bar Control?
What is the use of Immediate, Local Window?
How do I implement an accelerator key for a text box?
To validate a range of values for a property whenever the property values changes,which type of property procedure you use?
___,__,___ are the type of combo box?
What is the-use of property page Wizard in ActiveX Control?
With in the form we want to check all the text box control are typed or not? How?
How do I do Peek and Poke and other low-level stuff?
1s it posible to Create Tables Through Querydef?
How many objects resides in ADO ?
What is "Reserved Error -1209"?
What is the difference between c++ and visual basic?
Explain Types of DBCombo boxes?
Explain about an event-driven programming language?
How would you use ActiveX Dll and ActiveX Exe in your application?