Can someone explain to me when to use what cursorlocation and locktype for opening recordset?
Printable View
Can someone explain to me when to use what cursorlocation and locktype for opening recordset?
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.
Thanks but I know all of that already. That is cursor type.
I am looking to understand cursorlocation(clientside, serverside) and locktype.
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
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. :)Quote:
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