http://www.perlmonks.org?node_id=518475


in reply to Locking a table row while web form is open

An easier approach is to add two columns. LockedBy and LockedOn. When a user begins an edit, lock the record recording the ID and the Time. When they commit remove the lock. Don't let anyone edit the record if it has a lock, or let them see who locked it when and force remove the lock. This way you can also expire locks that are X minutes old, or when a users session ends, remove all there locks. I've used this approach before and it works rather well.


___________
Eric Hodges $_='y==QAe=e?y==QG@>@?iy==QVq?f?=a@iG?=QQ=Q?9'; s/(.)/ord($1)-50/eigs;tr/6123457/- \/|\\\_\n/;print;
  • Comment on Re: Locking a table row while web form is open

Replies are listed 'Best First'.
Re^2: Locking a table row while web form is open
by graq (Curate) on Dec 22, 2005 at 08:55 UTC

    Do you know what the management loves? They love a little javascript ticker that shows how long until the lock times out - gives the person editing a sense of urgency and when it clicks down to 0 seconds they know they will have to start again...

    Now I find it a naff idea - but I don't pay my wages.