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 |
How can we find out that a recordset is blank (without using recordcount property)?
Dim X,Y as Integer Here what is the datatype of X and Y ?
Types of LockEdits in DAO? 51 .Types of Recordsets.
What is binding? What are types of binding?
what is the difference between vb and vb.net
what are the Types of Modal windows in VB?
___ property is used to change to ___ value to access a identity column'in datacontrols.
Why does everybody say I should save in TEXT not BINARY?
How can you check whether a record is valid record or Invalid record using ADO control or Object?
What is FireHouse Cursors?
What is the need of z-order method?
What is the use of Data Form Wizard?
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)