Managing Concurrent Users
- Single Page
Posted 26 April 2012 - 16:10 PM
For example: There is a row with 'Value' = 200. User A starts editing the row and User B comes along at the same time and changes 'Value' to 1000 and presses update. Then User A finally finishes editing and changes 'Value' to 500 and presses update.
User B's changes will be completely lost and only User A's changes will take effect.
I think the best method would be to stop other users from editing the record if someone is currently editing it. Is there any easy way to achieve this?
Posted 27 April 2012 - 05:31 AM
Posted 28 April 2012 - 02:43 AM
maybe add a field on your table that will indicate some using the said row and create a function that will check whether it is being used or not.