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 |
Difference between ActiveX Exe and Dll.
How do I call help files from a VB program?
Whats the advantages/disadvantages of using datacontrol vs DAO/ADO/RDO?
1 Answers L&T, MAHINDRA, Teledata,
What does Query_unload event do in VB? Why we need Form _unload event?
How can you check Beginning and End of the file?
what is the Advantage of ActiveX Dll over Active Exe ?
Is the Variant type slower than using other variable types?
how a multiple routing works ?
Types of cursors in RDO.
Explain the creation project schedule.
What is the difference between a Property Let and Property Set procedure?
What is the difference between modal and module-less window?
Visual Basic (800)
C Sharp (3816)
ASP.NET (3180)
VB.NET (461)
COM+ (79)
ADO.NET (717)
IIS (369)
MTS (11)
Crystal Reports (81)
BizTalk (89)
Dot Net (2435)
Exchange Server (362)
SharePoint (720)
WCF (340)
MS Office Microsoft (6963)
LINQ Language-Integrated Query (317)
WPF (371)
TypeScript (144)
Microsoft Related AllOther (311)