Results 1 to 2 of 2

Thread: Table Locking

  1. #1
    Join Date
    Dec 2003

    Question Unanswered: Table Locking

    Can someone please help me with ideas on how to accomodate a client request?

    I have a online transaction with a substantial unit of work that reads many different tables. When the user selects a patient, they would like THAT patient locked from viewing from any other user. No other tables need to be locked.

    Thank you in advance,

  2. #2
    Join Date
    Apr 2003
    Phoenix, AZ

    Re: Table Locking

    The application would need to be modified to change the issolation mode of both the updater and anyone viewing. The program that needs the lock would update the record, setting the lock.

    Another option would be to set a flag in the record at the start and have all others check for flag being set.

    Either way, it's a program mod.
    Fred Prose

Posting Permissions

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