Are there any set rules for programmers to code for updating the same record at the same time in a multiuser environment?
For example:
Two users of the system display the same details on each of their screens.
User A makes a change to the record and presses update. User B does not make a change to the record but still presses update. Should the record on the database have User B's details?
Are there any hard and fast rules for record locking in multiuser environments?
Both users in the example above should be allowed to view the record. But how should the system cope with the updates?