CursorLocation and LockType

[Hawk]

Can someone explain to me when to use what cursorlocation and locktype for opening recordset?

[tripod657]

adOpenForwardOnly - Static copy of records. Doesn't reflect changes done by other users. Can only move forward through the recordset.

adOpenStatic - Also a static copy of records. However all types of movement are supported.

DAO adOpenDynamic - Non-static copy of records. Shows changes done by other users. All types of movement supported.

DAO adOpenKeyset - Records are updateable. However additions and deletions don't appear.

[Hawk]

Thanks but I know all of that already. That is cursor type.

I am looking to understand cursorlocation(clientside, serverside) and locktype.

[mendhak]

adLockReadOnly (Default) Read-only — users cannot alter the data.
adLockPessimistic Pessimistic locking, record by record — the provider does what is necessary to ensure successful editing of the records, usually by locking records at the data source immediately upon editing.
adLockOptimistic Optimistic locking, record by record — the provider uses optimistic locking, locking records only when the Update method is called.
adLockBatchOptimistic Optimistic batch updates — required for batch update mode as opposed to immediate update mode.


cursor location:
http://msdn.microsoft.com/library/en...idecursors.asp

[Hawk]

Thanks Mendhak,

You and JoshT has helped me quite a bit on ASP questions in the past.

By any chance, do you know anything about this one?

http://www.vbforums.com/showthread.php?threadid=232076

Thanks again,

Hawk

[mendhak]

Originally posted by Hawk
Thanks Mendhak,

You and JoshT has helped me quite a bit on ASP questions in the past.

By any chance, do you know anything about this one?

http://www.vbforums.com/showthread.php?threadid=232076

Thanks again,

Hawk

You're welcome, and click here.