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


Please Help Members By Posting Answers For Below Questions

What is Parser Bug?

1873


Is there any way to pass a variable to a form apart from using global variables?

1081


How do you change the icon and otherwise manipulate the DOS box?

1096


What is the difference between change event in normal combobox and dbcombobox?

1782


Explain the creation project schedule.

590






What is dao in visual basic?

527


What is understand in resource tracking?

675


How do I tell when an application executed using the SHELL command is finished?

1093


What is the use of ActiveX Documents?

1575


How would you map properties to controls by using ActiveX Control Interface Wizard?

1711


What about DLL calls that require callbacks?

985


How would you Create a Query Builder and Explain its uses ?

1618


what are the different Types of Recordsets.

1537


Types of LockEdits in DAO?

1678


How do I create a window with a small title bar as in a floating toolbar?

863