>we have a screen in vfp5 that we want to have a grid and a button under it. When the user pushes the button, a sql statement executes and the grid should fill with data. We see the data is pulled in on the status line but it does not populate the grid. If we manually run the sql before the screen is run, the grid is populated....Refresh doesn't seem to get it. Am I missing something here? I thought REQUERY was the answer but it does not seem to be for grids.
Ed, when you re-run SQL your grid looses RecordSource. You have to reset record
source after SOL, but in general it is better to use a view as grid.RecordSource, REQUERY(), and grid.Refresh()
HTH,
Nick
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro
"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison