Someone that can tell me a little about how and when to use a CursorTypeEnum & LockTypeEnum.
'---- CursorTypeEnum Values ----
Const adOpenForwardOnly = 0
Const adOpenKeyset = 1
Const adOpenDynamic = 2
Const adOpenStatic = 3
'---- LockTypeEnum Values ----
Const adLockReadOnly = 1
Const adLockPessimistic = 2
Const adLockOptimistic = 3
Const adLockBatchOptimistic = 4
I know that if i want to read from a database i use ,0 ,1 or ,adOpenForwardOnly ,adLockReadOnly
but what about if i add a new record or will edit a record.
and what can i use adLockBatchOptimistic and so on till !?
One other question
CursorLocation !?? Should I use that as well as CursorType and LockType !? or is it ok just to use Cursor and Lock Type !?
and what do CursorLocation do !??