I'm writing an application using (from back to front) MySQL, XSP (esql), XPS
As there could potentially be multiple users updating the same records (not a new problem :-) does anyone have a suggestion for the best way of locking records. My current idea is: Save the original value of each field in a hidden form element when opening the record Check to make sure no-one else has changed the record before applying any updates The hole I see in this is if someone updates a record in between checking and updating. Any suggestions to put me on the right track? Thanks Nigel ITM Business Solutions Unit 4 Nine Trees Trading Estate Morthen Road Rotherham S66 9JG Reception Tel: 01709 703288 Fax: 01709 701549 Help Desk Tel:01709 530424 Fax: 01709 702159 CONFIDENTIALITY NOTICE: This message is intended only for the use of the individual or entity to which it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
