On Thursday 17 June 2004 06.25, Stano Paska wrote: > Is there some common technique to notify another user, when he wants > open second dialog with same person, which is opened by first user at > the same time? > Another user sees on list of persons actual data, but this record is > already opened with first user and may be changed. There is possibility > to overwrite data changed by first user.
Sounds more application design than DB, anyway... Many ways to solve this... here's one way. Add a revision id column to your entries and you might have the following scenario: user 1 starts to change entry #2 with revision id 4. user 2 starts to change entry #2 with revision id 4. user 1 commits his changes, revision changes to 5. user 2 commits his changes. application checks revision id: 5 != 4. Application notifies user 2 about it. This will not completely eliminate overwriting unless user 1 locks during the revision check / commit but it will minimize the necessary locking time you need. > Has MySQL some capabilities for this? Some row level locking with check, > but no wait. http://dev.mysql.com/doc/mysql/en/Internal_locking.html Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
