What are different types of cursors in ADODB?

Answers were Sorted based on User's Feedback



What are different types of cursors in ADODB?..

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

What are different types of cursors in ADODB?..

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

What are different types of cursors in ADODB?..

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

What are different types of cursors in ADODB?..

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 are different types of cursors in ADODB?..

Answer / sr_arvind

Dinamic, optimistic, pecimistic ,

Is This Answer Correct ?    4 Yes 8 No

Post New Answer

More Visual Basic Interview Questions

What can you do with visual basic?

0 Answers  


What is the use of Connection object?

0 Answers  


What is the difference between adodc and adodb in vb?

0 Answers  


Which method is used to write context Into file?

2 Answers  


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?

0 Answers  






what are the Types of Modal windows in VB?

1 Answers  


Is visual basic case sensitive?

0 Answers  


Difference Types of Instancing Property in ActiveX Dll and Exe.

1 Answers  


Can a VB application be an OLE server?

0 Answers  


How do I create a window with a small title bar as in a floating toolbar?

0 Answers  


which property used to add a menus at runtime?

0 Answers  


How can you Navigate from the DHTML application to another DHTML application? .

0 Answers  


Categories