CursorType and LockType

Post Reply

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
Mikael Members Profile Find Members Posts Groupie Joined: 16 November 2002 Status: Offline Points: 151	Post Options Post Reply Quote Mikael Report Post Thanks(0) Quote Reply Topic: CursorType and LockType Posted: 20 February 2003 at 5:37pm
	Can somebody explain to me what this will code do: rsNewPost.CursorType = 2 rsNewPost.LockType = 3 Does it lock a post in the database so it doesn't double-recording?

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply Posted: 20 February 2003 at 5:42pm
	The lock type of 3 will look the db while it is updated otherwise if someone else tries to update it at the same time or accesses it, it could corrupt the database.
	Web Wiz Forums Hosting ASP.NET Web Hosting

Mikael Members Profile Find Members Posts Groupie Joined: 16 November 2002 Status: Offline Points: 151	Post Options Post Reply Quote Mikael Report Post Thanks(0) Quote Reply Posted: 21 February 2003 at 1:59am
	And the CursorType?

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply Posted: 21 February 2003 at 4:47am
	I can't remeber offfhand, I think that could be a dynamic one for moving around the recordset. The values there are the interger values, have a look on MSDN for the correct full names of these cursor and locktypes to see what they do.
	Web Wiz Forums Hosting ASP.NET Web Hosting

dolby71 Members Profile Find Members Posts Senior Member Joined: 27 October 2002 Location: Israel Status: Offline Points: 203	Post Options Post Reply Quote dolby71 Report Post Thanks(0) Quote Reply Posted: 21 February 2003 at 6:23am
	OK Thanks. I wanted to know that too...

Post Reply

Forum Jump

Forum Permissions View Drop Down

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

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.