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 |
How do I call a DLL?
What type of record sets are available in ADO?
What is database vb?
What does Addressof operator do?
What is Static Variable?
which arguments will be used to run a executable program in shell function ?
Difference between Linked Object and Embedded Object?
What is the tool used to configure the port range and protocols for DCOM communications?
Scope of API?s can be of different types, what are they Why API functions are Required?
What is ActiveX Document?
what is the diff between inprocess and out of process ?
What is Implicit?