>>>Set refresh to 1 means to refresh every grid every second!!! With many records your grids won't even have the time to refresh before another refresh is called. I suggest that you set this to 0 and instead add a button to refresh the grid(s), if it's necessary at all.
>>>
>>
>>AFAIK Grids are not affected by the setting of REFRESH. Browses are but they have no biss. in an app.
>
>Since Browse is basically a sell around a grid, I would guess the Refresh setting applies, but I may be wrong. Anyway, I always have Set Reresh to 0 in my startup program.

from the "Bible" ;) :
"A BROWSE shows a number of records on the screen at any one time, but other users might be changing those records as you watch. If REFRESH is left at its default state of 0,5, these changes are never displayed. For table fields displayed with other controls, you must lock a record to be sure the fields display the actual values stored on disk, but REFRESH can "read through locks" to show you the most up-to-date information available while within a BROWSE.

We generally feel that BROWSEs should not be used in applications; instead, they should be replaced by the far more controllable Grid. See "Commands Never to Use" for more details. Grids don't seem to be affected by the setting of REFRESH, requiring either that the row receive the focus, the form's Activate event occur, or the form's Refresh method be called in order for data to be properly displayed.

The second parameter is less well documented. This parameter supposedly determines how often the locally cached data buffers should be updated with new data. Don't ever set this parameter to zero, or you won't see changes made to records displayed on screen until the records are locked.

It seems to us that the default setting of 5 seconds should beat the server to death with so many requests to update data that the entire system would come crashing down, but that hasn't been our experience. On very large systems or WANs where network bandwidth is a precious commodity, we recommend you try raising the refresh level by doubling it and checking the performance change to the network and application. Ten, 20 or even 40 seconds between updates might not make that much difference in the appearance of your application, but could significantly affect other network performance criteria. As always, your mileage may vary; test your application under your environment to be sure of optimal performance."