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 Recordset and Resultsets.
Which property of menu cannot be set at run time?
what is the control used to call a windows application.
What is DAO?
What is "NULL"?
Types of cursors in RDO.
Explain the differences between ActiveX Dll and ActiveX Exe?
____ property of menu cannot be set at run time.
What is the use of Imagelist Controls ?
What is shortcut menu and explain "The ole control's shortcut menu".
How can you check whether a record is valid record or Invalid record using ADO control or Object?
What are the different types of Dialog Box?