>The main screen in our system was running very slow with a filter set on. We found that by adding the command "SET REFRESH TO 0,0" the form runs much faster. It had always been at "0,5" and we never paid any attention to it. It always worked until our largest customer got 6 years of data. I now need to know if there is a command to do a data refresh. (not the form refresh) If you run the form and skip through the data it will not show changes made by another user on the network until you lock the record. I am drawing a blank here but I know there is a command to do this.
>
>Thanks in advance.
If you issue a lock on a record in the table or on the table header, the data will be refreshed in the local cache.
rlock(0)
unlock
You could stick this in a timer on your form or just call it when you need it.
HTH.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao