this thread has been covered a few times. The last time was (from memory) was started by "rob" about 3 months ago.
check the archives. lots of good ideas using timestamps and flags, etc, to cover people locking a record and then walking away. Barry Beattie CF Web Developer Alpha Business Systems [EMAIL PROTECTED] � Ph: +61 07 3216 0999 � Unit 1, 31 Thompson Street Bowen Hills QLD 4006 www.alphabus.com.au � Virus Disclaimer: Please note that this email may contain computer-generated file(s) as an attachment.� Whereas we take every effort to protect our files from computer virus, we recommend that you check the file(s) with your own virus detection software prior to opening it.� If you would prefer to receive a hardcopy of the file please email or phone. Alpha Business Systems does not accept liability for the consequences of any computer viruses that may be transmitted with this email. Confidentiality: This email and any attached files are intended solely for the addressee(s) and may contain confidential and privileged information. If you received this email in error, please advise us by return email or phone and disregard the contents and immediately delete it and destroy any copies -----Original Message----- From: KNOTT, Brian [mailto:[EMAIL PROTECTED] Sent: Friday, 11 June 2004 8:18 AM To: CFAussie Mailing List Subject: [cfaussie] RE: Locking records being edited Jamie, That's how I would do it. Also have an extra field so you can tell who is editing it or you will not know who can update it. Brian > -----Original Message----- > From: Jamie Lawrence Jenner [SMTP:[EMAIL PROTECTED] > Sent: Friday, 11 June 2004 4:49 > To: CFAussie Mailing List > Subject: [cfaussie] Locking records being edited > > hello again > > Is there any way to lock a record while a user is updating it. i have a > multi user inventory for a large car company. If two users open the same > record and make changes, then the one will overwrite the other. Is there > any way in which the record can be locked while a user updates it. > > I have thought maybe i could have a time field, and when a record is > retrieved for editing, set this to 5 mins in the future, then if Now() > < timefield, record is locked by other user. Obviously, the end user would > have only 5 mins to edit, which is not very eficient. > > im just thinking out loud here. > > What are your views? > > cheers > > jmao > > --- > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] > To unsubscribe send a blank email to > [EMAIL PROTECTED] > Aussie Macromedia Developers: http://lists.daemon.com.au/ ----------------------------------------------------------------------------------- This e-mail is sent by Suncorp-Metway Limited ABN 66 010 831 722 or one of its related entities ("Suncorp"). Suncorp may be contacted at Level 18, 36 Wickham Terrace, Brisbane or on 1800 689 762 or at suncorp.com.au. The content of this e-mail is the view of the sender or stated author and does not necessarily reflect the view of Suncorp. The content, including attachments, is a confidential communication between Suncorp and the intended recipient. If you are not the intended recipient, any use, interference with, disclosure or copying of this e-mail, including attachments, is unauthorised and expressly prohibited. If you have received this e-mail in error please contact the sender immediately and delete the e-mail and any attachments from your system. If this e-mail constitutes a commercial message of a type that you no longer wish to receive please reply to this e-mail by typing Unsubscribe in the subject line. --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
