We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

Pessimistic Locking

paulca
paulca asked
on
Medium Priority
145 Views
Last Modified: 2010-05-03
I have a database named School and a table named module.  When I enter the edit mode I am able to change information.  If I am in edit mode and someone else tries to manipulate the record I am working on, I want an error to occur when the second user hits the Save button.  I am using SQL for all my searches, adds, updates, and deletes.  Can you give me the code that will accomplish this procedure?
Comment
Watch Question

Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
I was also looking for the errot trapping code.  I'll add another 5 points since I was not specific with that point.

Commented:
Your error handler might look like this:

On Error Goto HandleError
'
'Process code here
'
Exit Sub

HandleError:
If Err.Number = 3186 Then
  'The user attempted to update a page that contains a read lock placed by another user.
  nRes = MsgBox("Another user has this record locked.  Try again?", vbYesNo + vbQuestion, "Write Error")
  If nRes = vbYes Then
    Resume
  Else
    Exit Sub
  End If
Else
  'Handle other errors
End If

Commented:
Modify the line to read:
If Err.Number = 3186 Or Err.Number = 3260 Then
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.