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 Parser Bug?
Is there any way to pass a variable to a form apart from using global variables?
How do you change the icon and otherwise manipulate the DOS box?
What is the difference between change event in normal combobox and dbcombobox?
Explain the creation project schedule.
What is dao in visual basic?
What is understand in resource tracking?
How do I tell when an application executed using the SHELL command is finished?
What is the use of ActiveX Documents?
How would you map properties to controls by using ActiveX Control Interface Wizard?
What about DLL calls that require callbacks?
How would you Create a Query Builder and Explain its uses ?
what are the different Types of Recordsets.
Types of LockEdits in DAO?
How do I create a window with a small title bar as in a floating toolbar?