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 |
Difference between Dynaset and Snapshot?
advantage and disadvantage in visual-basic and ms-access please tell me or send my mail-id
How come I get a "No Current Record" error when I use a a Data Control on an empty table?
What is dao in vb?
Through which protocol OLEDB components are interfaced?
What is frx?
List out controls which does not have events?
Using which type we can access file line by line?
What is the use of Scalewidth and ScaleHeight Proeperty?
Which method is preferred to save data like database to the disk?
What is the use of Active Control Property?
Explain Get, Let, Set Properties.