>Hi all,
>
>I have never really had to use Refresh(). But now I have been asked for one small part of an app where the users have multiple records loaded in a view if "can we know if someone else has just made a change to a record" (I have used optimistic locking up to now).
>
>I looked a Refresh() and CurVal() and have tried to test myself. I have also read Hackers Guide to VFP and it answered some, but not all, my questions:

If you're working with views, won't calling Requery for the view give you what you need? As I understand your situation, the workstation that wants to know if anyone else has changed anything won't have made changes, so you don't have an issue of uncommitted changes. You just need to ensure you have the most recent data, right?

Tamar