>I have a 350,000 records table. I have created a tag on DELETED() and another one on UPPER(myfield). From the command prompt, I can apply a filter and the browse is immediate. However, from a grid, when I apply a filter, the grid takes a while to response. Does that mean, the Grid and the Browse are 2 different controls? How can we obtain the same result in the grid when using a filter?
Michel, according to Mike Yearwood (FPAdvisor, July, 1997) the code underlying movement through a grid isn't Rushmore-aware, so a filter that causes large skips between records slows grid-refresh down substantially. In the same article he gave replacement code for Skip, Go Top, etc. which could be called in the grid KeyPress when using filtered records.
One suggestion might be to use LOCATE to get to the top of the filtered table before you start the grid refresh. With Rushmore optimization this might give you enough speed, as the movement between records in the filtered table wouldn't be too slow.
HTH
Barbara