>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:
ADO.NET automatically generates an exception (DBConcurrencyException) when a concurrency error is encountered. MM .NET automatically handles concurrency exceptions for you and displays a message to the end user. This code is found in the mmBusinessObject.HandleException() method. If you are using the mmBusinessForm's Save() method, the exception error is automatically displayed (showing the conflicting data), and the user is prompted for action. See mmBusinessForm.PostSaveProcessing() for details.
Regards,
Kevin McNeish
Eight-Time .NET MVP
VFP and iOS Author, Speaker & Trainer
Oak Leaf Enterprises, Inc.
Chief Architect, MM Framework
http://www.oakleafsd.com