Thanks Jim


>Use optimistic as it will force you to address the issues related to it. There is no such thing as pessimistic when using a backend server.


The issue I am trying to address at the moment is how to delete an invoice from the SQL server.

If user1 deletes the record but user2 already has a copy of that record in their buffer then the record will be saved again when user2 commits the changes.

I presume that I have to write code that notices this is what has happened and tells user2 that another user deleted the existing record.

Am I right about this