Print Page | Close Window

CursorTypeEnum & LockTypeEnum Question

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=10508
Printed Date: 28 March 2026 at 11:57am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: CursorTypeEnum & LockTypeEnum Question
Posted By: want2learn
Subject: CursorTypeEnum & LockTypeEnum Question
Date Posted: 19 May 2004 at 5:45am

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 !??




Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net