Update Out of Sync

[Chris Sharman]

>Here is the scenario.
>  User 1 & 2 both pull up the same data at the same time.
>
>  User 1 changes a value in the primary record.
>  User 1 performs an update which does the 'put product_ms'.
>  User 1 update performs postupdate procedure to copy the column
>         to the other table.

>  User 2 changes a value in a detail record.
>  User 2 performs an update, which skips the 'put product_ms' since
>         no fiels were changed for it.
>  User 2 update performs postupdate with old value that user 1 changed.

You should certainly move the designer file update loop from the postupdate
procedure to the update procedure.

I'm surprised you don't get a "record has changed since you found it" error
for the changed detail. Is it possible that user2 completes the detail
update first, before user1 does it in the postupdate ?

I'd recommend locking all the detail records, and the primary at the
beginning of the update procedure and unlocking them at the end.

Are the detail & designer unrelated, or could they be a detail & detail
secondary ? Or would that be possible even if they are unrelated ??

Is the problem on the detail or the designer ?

Chris



-----------------------------------------------------------------------

Any views expressed in this message are those of the sender and not
necessarily those of CCA Group.  The unauthorized use, disclosure,
copying or alteration of this message is forbidden.  The contents of
this message may be confidential and/or privileged, copyright CCA Group
and are intended solely for the use of the individual or entity to whom
they are addressed.  Whilst this message has been scanned, CCA Group
cannot guarantee that it is virus free or compatible with your systems
and accepts no responsibility for any loss or damage arising from its
use. The recipient is advised to run their own anti-virus software. If
you receive this message in error please contact
postmaster@ccagroup.co.uk immediately, destroy any copies and delete it
from your computer systems.