Classic ASP Discussion

Print Page | Close Window

CursorTypes

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=10599
Printed Date: 31 March 2026 at 1:17pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: CursorTypes

Posted By: zMaestro
Subject: CursorTypes
Date Posted: 25 May 2004 at 2:37pm

just a simple question?

what's the difference between:
CursorType = 1
CursorType = 3
?

sorry for this NewBie question

Replies:

Posted By: dpyers
Date Posted: 25 May 2004 at 4:43pm

Has to do with adds/changes/deletes made to records by other users while you're working with a record set that contains those records.

This table illustrates hoe activity by other users is visible - or not - in your recordset.

Type Adds Changes Deletes
1     No   Yes      No, Record in record Set Inaccessible
3     No    No      No, Record in record Set Accessible

For a type 1, you can't see new records that are added, but you can see changes made by other users while the record is in your recordset. You will still see a record that they deleted, but you can't access it's data fields.

For a type 3, You can't see any add, change or delete and you can still access date fields in a record that's been deleted.

-------------

Lead me not into temptation... I know the short cut, follow me.

Posted By: zMaestro
Date Posted: 25 May 2004 at 8:27pm

ok, although i didn't get it well, but I'll search for any topic regarding this... until then.... If I'm only reading from the database, what should I use?

Posted By: pmormr
Date Posted: 25 May 2004 at 10:07pm

look at http://www.w3school.com - www.w3school.com 's ASP ADO section.. they explain all the recordset stuff... i think (or was that my book... whatever)

-------------
Paul A Morgan

http://www.pmorganphoto.com/" rel="nofollow - http://www.pmorganphoto.com/

Posted By: pmormr
Date Posted: 25 May 2004 at 10:10pm

it was there... particularly this page: http://www.w3schools.com/ado/prop_rs_cursortype.asp - http://www.w3schools.com/ado/prop_rs_cursortype.asp

-------------
Paul A Morgan

http://www.pmorganphoto.com/" rel="nofollow - http://www.pmorganphoto.com/