Appendix

Team-Fly

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


ADO Examples and Best Practices
Ado Examples and Best Practices
ISBN: 189311516X
EAN: 2147483647
Year: 2000
Pages: 106

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net