Re: Concurrency / freshness of data objects [message #421 is a reply to message #419] |
Thu, 23 November 2006 17:39 |
AJM
Messages: 2371 Registered: April 2006 Location: Surrey, UK
|
Senior Member |
|
|
Generally speaking two people should not be updating the same information on the same object at the same time. If they are then there is something wrong with your administrative procedures.
The simple solution is to allow both updates, so which ever update is applied last is the one that 'sticks'.
It would be possible to cause the second update to fail if any data has changed between the 'read' and the 'update', but in my long experience this has rarely been requested by customers, and in those few cases were it has it has actually caused more problems than it solves.
In short, Radicore does not have any built-in method to protect against such updates. The real question should be "why would two different people be trying to update the same record at the same time?"
Tony Marston
http://www.tonymarston.net
http://www.radicore.org
|
|
|