On my previous project, I used a record version field in the table to check for concurrency. iRecVersion is an integer field and defaulted to 1. When I update a record, increment iRecVersion and check if it's the same:
UPDATE Customers SET Name = @sName, iRecVerion = iRecVersion + 1
WHERE iRecVersion = @iRecVer
Is this a recommended method in MM.NET? What is the best way to implement this in MM.NET?
Stephen Lee
--------------------------------
Too much to code
Too little time
--------------------------------