Automatic Locking

From: Bernadette Pinto <b.pinto_at_zetnet.co.uk>
Date: Wed, 26 Aug 1998 19:05:54 +0100
Message-ID: <1998082619055476740@zetnet.co.uk>

I need help on this urgently. Please respond!!

My problem is this:

Can someone explain (in beginner - speak) how automatic locking is handled in a multi - user environment? I am particularly curious about two users who are performing DML upon the same table but not committing their actions. What will happen when one commits before the other? What will happen to the row / columns which have been deleted when the other user attempts to update them? Are the table.rows flagged as deleted and thusly locked to the other user? Or, if the updating user manages to update first are these rows flagged as updated and thusly inaccessible? How does it work? I really appreciate any answer.

Thanks

B. Pinto Received on Wed Aug 26 1998 - 13:05:54 CDT