>Dear user group,
>
>We using the VFP to create our program but we encounter a lot of multi-user conflict problem when updated the data to the table by few user. We needs your advise.
>
>Problem: When few users running the program to update the same record at same table, and at the same time, some of the user's data is not updated.
>
>
>In my main program, I also try to SET REPROCESS TO 0, but the system is hang and one of the system displayed the message 'waiting for lock, please wait.....' until other user's system escape from the system. Then, some of the data is not updated.
>Dear All,
>
>We using the VFP to create our program but we encounter a lot of multi-user conflict problem when updated the data to the table by few user. We needs your advise.
>Problem: When few users running the program to update the same record at same table, and at the same time, some of the user's data is not updated. In my main program, I also try to SET REPROCESS TO 0, but the system is hang and one of the system displayed the message 'waiting for lock, please wait.....' until other user's system escape from the system. Then, some of the data is not updated.
>
>The table buffering mode in data environment is set to 5.
>e.g. coding
>Begin Trans
> sele table1
> seek code
> If !eof()
> =rlock()
> Repl field1 with field1 + lcfield
> unlock all
> endif
>End Trans
>
>If user1 is update 100.00 and user2 is update 200.00, as the result, the field1 at table1 is only updated by 100.00 (instead of 300.00).
>
>Actually we did tried to use SQL statement that is UPDATE to update the table (in which it have the automatic locking, accourding to VFP books), but it seems that it doesn't work.
>
>
>Thank You very much for your kindness.
Have you looked into buffering your data?

HTH,