Does anyone know where I can find some information and ADO cursors, or have an example they can show me? Gordon R. Durgha
gd@vslink.net
gd@vslink.net
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
ADO Cursors
- Thread starter GDX
- Start date
ADO has 4 main Cursor types:
2 non-updatable cursors :
adForwardOnly - non-updatable forward only scrolling, no MoveFirst or MoveLast. NonBookMarkable
asStatic - non-updatable, allows bi-directional scrolling, and allows MoveFirst and MoveLast. BookMarkable
2 Updateable cursors:
adUseKeySet - you see all updates to data that was retrieved and all you insertions, but not other users. Bidirectional Scrolling.
adUseDynamic - you see all insertions and updates, slowest but most powerfull. Bidirectional Scrolling.
For more information look at ADO 2.6 Programmers Reference by WROX - I think its the ADO bible, or try MSDN.
James
James Culshaw
jculshaw@active-data-solutions.co.uk
2 non-updatable cursors :
adForwardOnly - non-updatable forward only scrolling, no MoveFirst or MoveLast. NonBookMarkable
asStatic - non-updatable, allows bi-directional scrolling, and allows MoveFirst and MoveLast. BookMarkable
2 Updateable cursors:
adUseKeySet - you see all updates to data that was retrieved and all you insertions, but not other users. Bidirectional Scrolling.
adUseDynamic - you see all insertions and updates, slowest but most powerfull. Bidirectional Scrolling.
For more information look at ADO 2.6 Programmers Reference by WROX - I think its the ADO bible, or try MSDN.
James
James Culshawjculshaw@active-data-solutions.co.uk
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question