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 |
To set the command button for ESC, Which property needs to be changed?
What is ActiveX Explain?
What is the difference between COM and DCOM?
9 Answers 7 Seas, American Infoserv, Microsoft, SRMSCET,
which argument can be used to make a menu item into bold?
Which Property is used to compress a image in image control?
What is the difference between queryunload and unload in form?
Write the steps in Creating ActiveX Dll and Active Exe?
What are the types of Error?
How many max. number of controls can place in one form (especially visual basic form)?
What is the diff between the Create Object and Get object?
What is OLEDB?
How would you run your ActiveX Document Dll?