Prevent Concurrent Data Modification

Applications such as Quickbooks or Saasu have a mechanism to prevent cocurrent edit. If you plan to integrate with Quickbooks or integrate with Saasu, this is the mandatory field when you are performing an update call:

  • Quickbooks uses a field called EditSequence
  • Saasu uses a field called LastUpdatedUid

 

This field value is automatically updated by the application after an update event. If two connections come in with the same value, one will succeed and one will fail.

 

This type of mechanism is also useful to prevent concurrent updates from a UI perspective. This is how it works:

  • PersonA is editing a customer named WDCi. (current EditSequence=1000)
  • PersonB is also editing a customer named WDCi using different machine (current EditSequence=1000)
  • PersonA completes the modification first and click the save button. The request is then submitted to the server with EditSequence=1000. Now the new EditSequence = 1001
  • PersonB completes the modification later and clicks the save button. The request is then submitted to the server with EditSequence=1000 but the server rejected the request because it does not match the latest EditSequence number (1001)

 

Get in touch today to see how WDCi can help your business.