I think it's possible I am having the following problem and I wonder whether you have any suggestions how to best prevent this from happening:
Person A loads model X of record nr 1234 and changes the field 'counter' to counter+1 Meanwhile, Person B loads model X of record nr 1234 and changes the field 'counter' to counter+2 However, person A and person B both loaded the same 'original model' with for example counter being 10. This means, person A stores counter = 11 and a bit later, person B seems to store counter = 12. Whereas I would want it to be counter = 13. This of course only happens occassionally.
It probably happens because the database isn't updates like 'counter = counter + 1' but more like 'counter =newvalueofmodelcounter'.
What is the best way to deal with this?