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 controls have you used in your project?
Explain about creating VB applications in excel?
which property used to add a menus at runtime?
What is Seek Method which type of record set is available this?
How would you navigate between one document to another document in Internet Explorer ?
What is ado data control in vb6 0?
Discuss the working with to-do lists.
Specify technical & functional architecture of your last 2 projects.
What is the use of Tabledef?
When should we use recursive programming?
Explain about Caturing Baseline.
Why doesn't "my string" & Chr$(13) do what I want?
What are the types of line styles available in Treeview Control?
How to use advanced data-bound controls.
How can you get selected file from file system Control?