Results 1 to 4 of 4

Thread: Applying lock

  1. #1
    Join Date
    Aug 2013

    Unanswered: Applying lock

    I want to apply lock on a row, where by when another application is trying to access the locked row the application will automatically move to the next row instead of waiting for the locked row

  2. #2
    Join Date
    Feb 2004
    In front of the computer
    Provided Answers: 54
    Depending on the client, it may be possible to set this behavior there. If the client is running a script, you could always modify that script.

    I don't know of any way (in any database engine) to set this type of behavior. It would probably be considered a bug instead of a feature!

    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  3. #3
    Join Date
    Aug 2008
    Would that be all types of access - including SELECT , or do you mean just UPDATE and DELETE?

  4. #4
    Join Date
    Aug 2013


    Thanks for your concern the access is only SELECT

Posting Permissions

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