Hi friends!

I have a question that I've had for some time now. And always forget to ask:
Does anybody know what the REFRESH() function is useful for? I mean the Refresh() function not the Refresh() method.
I think the help file is not very clear at explaining what it really does.
At first it is something like the REQUERY() function but not at all.
Can anybody explain it in a more clear fashion?


With REFRESH you can requery only current record or a range around the running record.

A simple example:

- put a RV into a grid with 10 visible rows
- on Column1.DynamicFontShadow = "EMPTY(REFRESH(10,10,m.this.Recordsource))"

You can have a automatic refresh for the backend data,
without a big impact even if reccount(m.this.Recordsource)>100000.

Other examples:
- monitor of shared dynamic data,
- check when remote rows locked are unlocked
- write a shared data area for intraclient communications.
- refresh a VFP cache database for the backend database
- Etc....