|
-
Jul 21st, 2007, 09:20 PM
#7
Thread Starter
No place like 127.0.0.1
Re: Locking a row from being READ
Simplicity was the key!
That's it.
Here's what I was thinking before you mentioned checking the affected rows: In the "undesirable scenario" I wouldn't have checked the number of rows affected by the update and both scripts would have gone on with the 60 seconds of processing.
You're very correct, though. If I simply make sure that the update affected one row, I'm fine. If it didn't affect one row, then I will just keep doing queries until I get a row that I can successfully update.
Perfect! I haven't coded it yet, but I understand the concept.
Thanks so much szlamany. RobDog and Penagate told me you were the SQL master. That seems to be the case.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|