Misi has something as well. http://www.rrr.se/en/products/rrrlock.html
There's a flowchart there that will give you the general idea. Thad Esser Remedy Developer "Did you ever wonder why we had to run for shelter when the promise of a brave new world unfurled beneath a clear blue sky?" - Pink Floyd |------------> | From: | |------------> >--------------------------------------------------------------------------------------------------------------------------------------------------| |Joe DeSouza <joe_rem...@yahoo.com> | >--------------------------------------------------------------------------------------------------------------------------------------------------| |------------> | To: | |------------> >--------------------------------------------------------------------------------------------------------------------------------------------------| |arslist@ARSLIST.ORG | >--------------------------------------------------------------------------------------------------------------------------------------------------| |------------> | Date: | |------------> >--------------------------------------------------------------------------------------------------------------------------------------------------| |07/29/2009 08:14 AM | >--------------------------------------------------------------------------------------------------------------------------------------------------| |------------> | Subject: | |------------> >--------------------------------------------------------------------------------------------------------------------------------------------------| |Re: Blocking request for editing by another user | >--------------------------------------------------------------------------------------------------------------------------------------------------| |------------> | Sent by: | |------------> >--------------------------------------------------------------------------------------------------------------------------------------------------| |"Action Request System discussion list(ARSList)" <arslist@ARSLIST.ORG> | >--------------------------------------------------------------------------------------------------------------------------------------------------| ** Hello Andrey, Set up a flag that gets updated with a direct SQL with the LoginID of the person who first opened the ticket, the moment the first person opens the ticket for editing, and display a warning that the ticket is being edited by another user if some other user opens the same ticket.. Reset this flag to null the moment the first user closes or saves the ticket. That may be the quickest and dirtiest way of doing it. Joe From: Andrey <lice...@gmail.com> To: arslist@ARSLIST.ORG Sent: Wednesday, July 29, 2009 9:32:44 AM Subject: Blocking request for editing by another user Hi list How can I avoid simultaneous editing of the request by different users? Thank for advice _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ *IMPORTANT NOTICE: This communication, including any attachment, contains information that may be confidential or privileged, and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message is strictly prohibited. Nothing in this email, including any attachment, is intended to be a legally binding signature. * _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"