Results 1 to 2 of 2

Thread: Select and update SQL

  1. Jun 18th, 2003, 02:50 PM #1
    Cin0s3
    Cin0s3 is offline

    Thread Starter
    Lively Member
    Join Date
    Jan 2001
    Location
    Worcester, MA
    Posts
    77

    Select and update SQL

    I need to select a value from a field and then add 1 to it and return that value. I know I have to do 2 queries to accomplish this but I need to do it so someone cant do the same thing at the same time. Is there a way to lockout that field until I update it in SQL?
    "Find all you need in your mind if you take the time" -DT
    Reply With Quote Reply With Quote
  2. Jun 19th, 2003, 11:14 AM #2
    Arkhos
    Arkhos is offline
    Member
    Join Date
    Jun 2003
    Posts
    63
    This should do it...

    http://www.aspalliance.com/Michiel/recordlocks.asp
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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