Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - CursorTypes
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

CursorTypes

 Post Reply Post Reply
Author
zMaestro View Drop Down
Senior Member
Senior Member


Joined: 11 May 2003
Location: Egypt
Status: Offline
Points: 1183
Post Options Post Options   Thanks (0) Thanks(0)   Quote zMaestro Quote  Post ReplyReply Direct Link To This Post Topic: CursorTypes
    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

Back to Top
dpyers View Drop Down
Senior Member
Senior Member


Joined: 12 May 2003
Status: Offline
Points: 3937
Post Options Post Options   Thanks (0) Thanks(0)   Quote dpyers Quote  Post ReplyReply Direct Link To This Post 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.



Edited by dpyers

Lead me not into temptation... I know the short cut, follow me.
Back to Top
zMaestro View Drop Down
Senior Member
Senior Member


Joined: 11 May 2003
Location: Egypt
Status: Offline
Points: 1183
Post Options Post Options   Thanks (0) Thanks(0)   Quote zMaestro Quote  Post ReplyReply Direct Link To This Post 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?
Back to Top
pmormr View Drop Down
Senior Member
Senior Member


Joined: 06 January 2003
Location: United States
Status: Offline
Points: 1479
Post Options Post Options   Thanks (0) Thanks(0)   Quote pmormr Quote  Post ReplyReply Direct Link To This Post Posted: 25 May 2004 at 10:07pm
look at www.w3school.com 's ASP ADO section.. they explain all the recordset stuff... i think (or was that my book... whatever)
Back to Top
pmormr View Drop Down
Senior Member
Senior Member


Joined: 06 January 2003
Location: United States
Status: Offline
Points: 1479
Post Options Post Options   Thanks (0) Thanks(0)   Quote pmormr Quote  Post ReplyReply Direct Link To This Post Posted: 25 May 2004 at 10:10pm
it was there... particularly this page: http://www.w3schools.com/ado/prop_rs_cursortype.asp
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.