Hi BP--

0. User A loads Record R.
1. User B loads Record R.
2. User B edits and saves Record R.
        (Saving involves starting a transaction, retrieving R from the DB,
comparing the values with the original values to make sure it is 
        the same record, and then the UPDATE and then commiting the
        transaction).
3. User A edits and saves Record R.
        (Saving involves starting a transaction, retrieving R from the DB,
comparing the values with the original values to make sure it is 
        the same record, and when it's not, rolling back the transaction and
        notifying the user that the record has already been modified by 
        another user or process).

Hope this helps!
Doug

At 02:02 AM 8/29/01 GMT, Bopolissimus Platypus wrote:
>hello all,
>
>I've got a question about what's got to be a common problem.
>I'm sort of doing a survey to see how others have solved this
>problem before so that I can choose one that's best for me.
>
>Basics:
>    The software is a web based data entry system.
>    Sessions are maintained (so that users don't have to
>         login after every database operation, and for 
>         security - users can only perform actions that
>         are allowed to their login or group0.
>
>Use Case:    
>0.   User A loads Record R.
>1.   User B loads the same Record R.
>2.   User B edits and saves Record R.
>3.   User A edits and saves Record R.
>    
   [--snip--]

--Doug's Signature File----------------------------------------
~ ~ ~ I'm proud to work for GLISnet,  Michigan's best ISP ~ ~ ~
--1.888.445.4763---8am to 8pm every day---http://www.glis.net--
    The views and opinions expressed in this email are my
    own and may not be those of my employer.


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to