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/
