CursorType: ADODB Recordset object exposes CursorType property which takes following cursor types derived from CursorTypeEnum. CursorType property is used to specify the type of cursor that should be used when opening the Recordset object.:
- adOpenForwardOnly: its default cursor type, ensures the cursor moves forward in the recordset
- adOpenKeyset: supported methods adBookmark, adHoldRecords, adMovePrevious, adResync
- adOpenDynamic: adMovePrevious
- adOpenStatic: Supported methods adBookmark, adHoldRecords, adMovePrevious, adResync. CursorLocation must be set to adUseClient
adUpdateBatch may be true for dynamic and forward-only cursors, for batch updates you should use either a keyset or static cursor. Set the LockType property to adLockBatchOptimistic and the CursorLocation property to adUseClient to enable the Cursor Service for OLE DB, which is required for batch updates.
Please leave your comments or queries under comment section also please do subscribe to out blogs to keep your self upto date.