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 |
Through which protocol OLEDB components are interfaced?
Is visual basic still used?
How can you check whether a record is valid record or Invalid record using ADO control or Object?
How to test the AX stat class?
what is the Advantage of ActiveX Dll over Active Exe ?
What are the different compatibility types when we create a COM component?
Is there any Edit method in ADO Data Access method?
How would you attach an ActiveX control in Your Application?
How do I call help files from a VB program?
How would you access objects created in ActiveX Exe and ActiveX D1T ?
What is ADO?
How can I access a record by record number?