Name the four different cursor and locking types in ADO ?



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

Post New Answer

More Visual Basic Interview Questions

To set the command button for ESC, Which property needs to be changed?

1 Answers  


What is ActiveX Explain?

2 Answers   SDS,


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?

2 Answers  


Which Property is used to compress a image in image control?

1 Answers  






What is the difference between queryunload and unload in form?

2 Answers  


Write the steps in Creating ActiveX Dll and Active Exe?

0 Answers  


What are the types of Error?

1 Answers   IBM,


How many max. number of controls can place in one form (especially visual basic form)?

6 Answers   Satyam,


What is the diff between the Create Object and Get object?

2 Answers  


What is OLEDB?

0 Answers  


How would you run your ActiveX Document Dll?

0 Answers  


Categories