Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2004
    Posts
    1

    getting right actual rest

    Sorry for my ugly english.
    there is a situation: two database users are trying simultaneously to sale good (name it good1) of amount of 5 pieces each of user. at depot we have just 5 pieces of good1. and one of these sale documents should not be permitted. who to do it on SQL database?

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Use database locking mechanism to ensure that only 1 user at a time can update the stock for a given item. Google for "optimistic pessimistic locking".

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •