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

Through which protocol OLEDB components are interfaced?

0 Answers  


Is visual basic still used?

0 Answers  


How can you check whether a record is valid record or Invalid record using ADO control or Object?

0 Answers  


How to test the AX stat class?

0 Answers  


what is the Advantage of ActiveX Dll over Active Exe ?

1 Answers  






What are the different compatibility types when we create a COM component?

2 Answers  


Is there any Edit method in ADO Data Access method?

0 Answers  


How would you attach an ActiveX control in Your Application?

0 Answers  


How do I call help files from a VB program?

0 Answers  


How would you access objects created in ActiveX Exe and ActiveX D1T ?

0 Answers  


What is ADO?

1 Answers   Satyam,


How can I access a record by record number?

0 Answers  


Categories