What are different types of cursors in ADODB?
Answers were Sorted based on User's Feedback
Answer / venkatesh
we have four types of cursors in ADODB method
1.static
2.dynamic
3.keyset
4.Forward only
Is This Answer Correct ? | 18 Yes | 1 No |
Answer / pranita
there are four cursors in ADODB
1.Forward only-allows to move forward only through a
recordset.
2.keyset-allows to move forward and backward through
recordset.reflects modifications and deletions done by
other users.
3.dynamic-allows to move through a recordset.reflects all
changes made by another user.
4.static-allows to move forward and backward through a
recordset.does not reflect any changes made by the other
users.
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / hema
1.Dynamic Recordsets
- it allows viewing the result of add,modify &
deletion by other users.
2.Keyset Recordsets
- it same as Dynamic rs but prevents seeing of
changes by the other users.
3.Static Recordsets
- the static copy of a set of records to find data
or generate reports.
4.Forward-only
- it improve performance.it behaves identical to a
static recordset and allows forward-only
Is This Answer Correct ? | 4 Yes | 3 No |
Answer / shri vardhan gupta
Cursor Type: Cursor can be various types:
Adopendynamic: The resultset reflects changes ,addition and deletion. Resultset can be navigated anyway.
Adopenforwardonly:The resultset reflects changes ,addition and deletions.can be navigated in forward direction only.
Adopenkeyset:The resultset reflects modifcations to data but not records addded by other users.
Adopenstatic:returns the static set of records cannot be modified.
Is This Answer Correct ? | 0 Yes | 0 No |
What can you do with visual basic?
What is the use of Connection object?
What is the difference between adodc and adodb in vb?
Which method is used to write context Into file?
VB ActiveX: Create a "drivelist"(D1) box, a "folderlistbox"(FLD1) that changes whenever D1 is changed , and a "FilelistBox"(FIL1) that is populated with the file lists under the selected directory in (D1).The file selected is stored in a variable "filename" along with the path. Question: How to use this activeX control in VC++ to get the selected filename?
what are the Types of Modal windows in VB?
Is visual basic case sensitive?
Difference Types of Instancing Property in ActiveX Dll and Exe.
Can a VB application be an OLE server?
How do I create a window with a small title bar as in a floating toolbar?
which property used to add a menus at runtime?
How can you Navigate from the DHTML application to another DHTML application? .