CursorLocation: Server-side Cursors
Cursor
FwdOnly MSDASQL
LockType Requested | CursorLocation | LockType Opened | CursorType | Updatable | AddNew | AbsPosition | BookMark | Delete | Holdrecords | MovePrevious | Resync | BatchUpdate | Seek |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
ReadOnly | Server | ReadOnly | FwdOnly | No | No | No | No | No | No | No | No | No | No |
Pessimistic | Server | Pessimistic | FwdOnly | Yes | Yes | No | No | Yes | No | No | No | Yes | No |
Optimistic | Server | Optimistic | FwdOnly | Yes | Yes | No | No | Yes | No | No | No | Yes | No |
Batch | Server | Batch | FwdOnly | Yes | Yes | No | No | Yes | No | No | No | Yes | No |
Keyset MSDASQL
LockType Requested | CursorLocation | LockType Opened | CursorType | Updatable | AddNew | AbsPosition | BookMark | Delete | Holdrecords | MovePrevious | Resync | BatchUpdate | Seek |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
ReadOnly | Server | ReadOnly | Keyset | No | No | No | Yes | No | Yes | Yes | Yes | No | No |
Pessimistic | Server | Pessimistic | Keyset | Yes | Yes | No | Yes | Yes | Yes | Yes | Yes | Yes | No |
Optimistic | Server | Optimistic | Keyset | Yes | Yes | No | Yes | Yes | Yes | Yes | Yes | Yes | No |
Batch | Server | Batch | Keyset | Yes | Yes | No | Yes | Yes | Yes | Yes | Yes | Yes | No |
Dynamic MSDASQL
LockType Requested | CursorLocation | LockType Opened | CursorType | Updatable | AddNew | AbsPosition | BookMark | Delete | Holdrecords | MovePrevious | Resync | BatchUpdate | Seek |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
ReadOnly | Server | ReadOnly | Keyset | No | No | No | Yes | No | Yes | Yes | Yes | No | No |
Pessimistic | Server | Pessimistic | Keyset | Yes | Yes | No | Yes | Yes | Yes | Yes | Yes | Yes | No |
Optimistic | Server | Optimistic | Keyset | Yes | Yes | No | Yes | Yes | Yes | Yes | Yes | Yes | No |
BatchO | Server | Batch | Keyset | Yes | Yes | No | Yes | Yes | Yes | Yes | Yes | Yes | No |
Static MSDASQL
LockType Requested | CursorLocation | LockType Opened | CursorType | Updatable | AddNew | AbsPosition | BookMark | Delete | Holdrecords | MovePrevious | Resync | BatchUpdate | Seek |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
ReadOnly | Server | ReadOnly | Keyset | No | No | No | Yes | No | Yes | Yes | Yes | No | No |
Pessimistic | Server | Pessimistic | Keyset | Yes | Yes | No | Yes | Yes | Yes | Yes | Yes | Yes | No |
Optimistic | Server | Optimistic | Keyset | Yes | Yes | No | Yes | Yes | Yes | Yes | Yes | Yes | No |
Batch | Server | Batch | Keyset | Yes | Yes | No | Yes | Yes | Yes | Yes | Yes | Yes | No |
FwdOnly SQLOLEDB
LockType Requested | CursorLocation | LockType Opened | CursorType | Updatable | AddNew | AbsPosition | BookMark | Delete | Holdrecords | MovePrevious | Resync | BatchUpdate | Seek |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
ReadOnly | Server | ReadOnly | FwdOnly | No | No | No | No | No | No | No | No | No | No |
Pessimistic | Server | Pessimistic | FwdOnly | Yes | Yes | No | No | Yes | No | No | No | Yes | No |
Optimistic | Server | Optimistic | FwdOnly | Yes | Yes | No | No | Yes | No | No | No | Yes | No |
Batch | Server | Batch | FwdOnly | Yes | Yes | No | No | Yes | No | No | No | Yes | No |
Keyset SQLOLEDB
LockType Requested | CursorLocation | LockType Opened | CursorType | Updatable | AddNew | AbsPosition | BookMark | Delete | Holdrecords | MovePrevious | Resync | BatchUpdate | Seek |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
ReadOnly | Server | ReadOnly | Keyset | No | No | Yes | Yes | No | Yes | Yes | Yes | No | No |
Pessimistic | Server | Pessimistic | Keyset | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No |
Optimistic | Server | Optimistic | Keyset | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No |
Batch | Server | Batch | Keyset | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No |
Cursor
Dynamic SQLOLEDB
LockType Requested | CursorLocation | LockType Opened | CursorType | Updatable | AddNew | AbsPosition | BookMark | Delete | Holdrecords | MovePrevious | Resync | BatchUpdate | Seek |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
ReadOnly | Server | ReadOnly | Keyset | No | No | Yes | Yes | No | Yes | Yes | Yes | No | No |
Pessimistic | Server | Pessimistic | Keyset | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No |
Optimistic | Server | Optimistic | Keyset | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No |
Batch | Server | Batch | Keyset | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No |
Static SQLOLEDB
LockType Requested | CursorLocation | LockType Opened | CursorType | Updatable | AddNew | AbsPosition | BookMark | Delete | Holdrecords | MovePrevious | Resync | BatchUpdate | Seek |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
ReadOnly | Server | ReadOnly | Keyset | No | No | Yes | Yes | No | Yes | Yes | Yes | No | No |
Pessimistic | Server | Pessimistic | Keyset | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No |
Optimistic | Server | Optimistic | Keyset | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No |
Batch | Server | Batch | Keyset | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No |
FwdOnly Jet 4.0
LockType Requested | CursorLocation | LockType Opened | CursorType | Updatable | AddNew | AbsPosition | BookMark | Delete | Holdrecords | MovePrevious | Resync | BatchUpdate | Seek |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
ReadOnly | Server | ReadOnly | FwdOnly | No | No | No | No | No | No | No | No | No | No |
Pessimistic | Server | Pessimistic | Keyset | Yes | Yes | No | No | Yes | Yes | Yes | No | Yes | No |
Optimistic | Server | Optimistic | Keyset | Yes | Yes | No | No | Yes | Yes | Yes | No | Yes | No |
Batch | Server | Batch | Keyset | Yes | Yes | No | No | Yes | Yes | Yes | No | Yes | No |
Keyset Jet 4.0
LockType Requested | CursorLocation | LockType Opened | CursorType | Updatable | AddNew | AbsPosition | BookMark | Delete | Holdrecords | MovePrevious | Resync | BatchUpdate | Seek |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
ReadOnly | Server | ReadOnly | Keyset | No | No | No | Yes | No | Yes | Yes | No | No | No |
Pessimistic | Server | Pessimistic | Keyset | Yes | Yes | No | Yes | Yes | Yes | Yes | No | Yes | No |
Optimistic | Server | Optimistic | Keyset | Yes | Yes | No | Yes | Yes | Yes | Yes | No | Yes | No |
Batch | Server | Batch | Keyset | Yes | Yes | No | Yes | Yes | Yes | Yes | No | Yes | No |
Dynamic Jet 4.0
LockType Requested | CursorLocation | LockType Opened | CursorType | Updatable | AddNew | AbsPosition | BookMark | Delete | Holdrecords | MovePrevious | Resync | BatchUpdate | Seek |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
ReadOnly | Server | ReadOnly | Keyset | No | No | No | Yes | No | Yes | Yes | No | No | No |
Pessimistic | Server | Pessimistic | Keyset | Yes | Yes | No | Yes | Yes | Yes | Yes | No | Yes | No |
Optimistic | Server | Optimistic | Keyset | Yes | Yes | No | Yes | Yes | Yes | Yes | No | Yes | No |
Batch | Server | Batch | Keyset | Yes | Yes | No | Yes | Yes | Yes | Yes | No | Yes | No |
Static Jet 4.0
LockType Requested | CursorLocation | LockType Opened | CursorType | Updatable | AddNew | AbsPosition | BookMark | Delete | Holdrecords | MovePrevious | Resync | BatchUpdate | Seek |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
ReadOnly | Server | ReadOnly | Keyset | No | No | No | Yes | No | Yes | Yes | No | No | No |
Pessimistic | Server | Pessimistic | Keyset | Yes | Yes | No | Yes | Yes | Yes | Yes | No | Yes | No |
Optimistic | Server | Optimistic | Keyset | Yes | Yes | No | Yes | Yes | Yes | Yes | No | Yes | No |
Batch | Server | Batch | Keyset | Yes | Yes | No | Yes | Yes | Yes | Yes | No | Yes | No |
Cursor
FwdOnly MSDASQL
LockType Requested | CursorLocation | LockType Opened | CursorType | Updatable | AddNew | AbsPosition | BookMark | Delete | Holdrecords | MovePrevious | Resync | BatchUpdate | Seek |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
ReadOnly | Client | ReadOnly | Static | No | No | Yes | Yes | No | Yes | Yes | Yes | No | No |
Pessimistic | Client | Batch | Static | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No |
Optimistic | Client | Optimistic | Static | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No |
Batch | Client | Batch | Static | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No |
Keyset MSDASQL
LockType Requested | CursorLocation | LockType Opened | CursorType | Updatable | AddNew | AbsPosition | BookMark | Delete | Holdrecords | MovePrevious | Resync | BatchUpdate | Seek |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
ReadOnly | Client | ReadOnly | Static | No | No | Yes | Yes | No | Yes | Yes | Yes | No | No |
Pessimistic | Client | Batch | Static | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No |
Optimistic | Client | Optimistic | Static | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No |
Batch | Client | Batch | Static | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No |
Dynamic MSDASQL
LockType Requested | CursorLocation | LockType Opened | CursorType | Updatable | AddNew | AbsPosition | BookMark | Delete | Holdrecords | MovePrevious | Resync | BatchUpdate | Seek |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
ReadOnly | Client | ReadOnly | Static | No | No | Yes | Yes | No | Yes | Yes | Yes | No | No |
Pessimistic | Client | Batch | Static | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No |
Optimistic | Client | Optimistic | Static | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No |
Batch | Client | Batch | Static | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No |
Static MSDASQL
LockType Requested | CursorLocation | LockType Opened | CursorType | Updatable | AddNew | AbsPosition | BookMark | Delete | Holdrecords | MovePrevious | Resync | BatchUpdate | Seek |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
ReadOnly | Client | ReadOnly | Static | No | No | Yes | Yes | No | Yes | Yes | Yes | No | No |
Pessimistic | Client | Batch | Static | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No |
Optimistic | Client | Optimistic | Static | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No |
Batch | Client | Batch | Static | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No |
FwdOnly SQLOLEDB
LockType Requested | CursorLocation | LockType Opened | CursorType | Updatable | AddNew | AbsPosition | BookMark | Delete | Holdrecords | MovePrevious | Resync | BatchUpdate | Seek |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
ReadOnly | Client | ReadOnly | Static | No | No | Yes | Yes | No | Yes | Yes | Yes | No | No |
Pessimistic | Client | Batch | Static | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No |
Optimistic | Client | Optimistic | Static | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No |
Batch | Client | Batch | Static | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No |
Keyset SQLOLEDB
LockType Requested | CursorLocation | LockType Opened | CursorType | Updatable | AddNew | AbsPosition | BookMark | Delete | Holdrecords | MovePrevious | Resync | BatchUpdate | Seek |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
ReadOnly | Client | ReadOnly | Static | No | No | Yes | Yes | No | Yes | Yes | Yes | No | No |
Pessimistic | Client | Batch | Static | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No |
Optimistic | Client | Optimistic | Static | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No |
Batch | Client | Batch | Static | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No |
Cursor
Dynamic SQLOLEDB
LockType Requested | CursorLocation | LockType Opened | CursorType | Updatable | AddNew | AbsPosition | BookMark | Delete | Holdrecords | MovePrevious | Resync | BatchUpdate | Seek |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
ReadOnly | Client | ReadOnly | Static | No | No | Yes | Yes | No | Yes | Yes | Yes | No | No |
Pessimistic | Client | Batch | Static | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No |
Optimistic | Client | Optimistic | Static | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No |
Batch | Client | Batch | Static | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No |
Static SQLOLEDB
LockType Requested | CursorLocation | LockType Opened | CursorType | Updatable | AddNew | AbsPosition | BookMark | Delete | Holdrecords | MovePrevious | Resync | BatchUpdate | Seek |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
ReadOnly | Client | ReadOnly | Static | No | No | Yes | Yes | No | Yes | Yes | Yes | No | No |
Pessimistic | Client | Batch | Static | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No |
Optimistic | Client | Optimistic | Static | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No |
Batch | Client | Batch | Static | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No |
FwdOnly Jet 4.0
LockType Requested | CursorLocation | LockType Opened | CursorType | Updatable | AddNew | AbsPosition | BookMark | Delete | Holdrecords | MovePrevious | Resync | BatchUpdate | Seek |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
ReadOnly | Client | ReadOnly | Static | No | No | Yes | Yes | No | Yes | Yes | Yes | No | No |
Pessimistic | Client | Batch | Static | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No |
Optimistic | Client | Optimistic | Static | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No |
Batch | Client | Batch | Static | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No |
Keyset Jet 4.0
LockType Requested | CursorLocation | LockType Opened | CursorType | Updatable | AddNew | AbsPosition | BookMark | Delete | Holdrecords | MovePrevious | Resync | BatchUpdate | Seek |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
ReadOnly | Client | ReadOnly | Static | No | No | Yes | Yes | No | Yes | Yes | Yes | No | No |
Pessimistic | Client | Batch | Static | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No |
Optimistic | Client | Optimistic | Static | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No |
Batch | Client | Batch | Static | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No |
Dynamic Jet 4.0
LockType Requested | CursorLocation | LockType Opened | CursorType | Updatable | AddNew | AbsPosition | BookMark | Delete | Holdrecords | MovePrevious | Resync | BatchUpdate | Seek |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
ReadOnly | Client | ReadOnly | Static | No | No | Yes | Yes | No | Yes | Yes | Yes | No | No |
Pessimistic | Client | Batch | Static | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No |
Optimistic | Client | Optimistic | Static | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No |
Batch | Client | Batch | Static | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No |
Static Jet 4.0
LockType Requested | CursorLocation | LockType Opened | CursorType | Updatable | AddNew | AbsPosition | BookMark | Delete | Holdrecords | MovePrevious | Resync | BatchUpdate | Seek |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
ReadOnly | Client | ReadOnly | Static | No | No | Yes | Yes | No | Yes | Yes | Yes | No | No |
Pessimistic | Client | Batch | Static | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No |
Optimistic | Client | Optimistic | Static | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No |
Batch | Client | Batch | Static | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes | No |
Team-Fly |