|
|
|
|
|
| | |
| |
Active Server Pages help tutorial how to ASP Help ASP Tutorials ASP Programming ASP Code - ASP Free CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
recordset locking? |
|
From: |
Ryan |
|
Date: |
10/13/1999 7:08:55 PM |
|
IP: |
166.37.22.178 |
I am currently selecting from a keytable. After the key is selected Im trying to incriment the key by a value of one.
Here is an example:
SQL = "SELECT key FROM getkey WHERE table = hello"
Set KeyTable = ObjConn.Execute(SQL)
UserID = KeyTable("key")
NewKey = CInt(KeyTable("key")) + 1
SQL = "UPDATE getkey SET key = " & NewKey & " WHERE table=hello"
Set NewKeyTable = objConn.Execute(SQL)
Set KeyTable = Nothing
Set NewKeyTable = Nothing
Multiple users will be accessing the page that performs the above SQL statements. What is the best method to lock a user from selecting the same recordset that another user is updating?
|
Follow Up - Re: recordset locking? - kal 10/18/1999 1:48:45 PM
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
