VFP, Refresh grid on form
Posted on 2010-08-27
Working in VFP9.0 SP2. This is the first time I'm trying to use a GRID. I thought I had this grid working, but with testing I find it is displaying old data some of the time.
I'm doing a one-to-many form using the grid for the many.
The grid is populated from a cursor ordered_lst useing a SQL statement.
SELECT ordered_lst.qty, part_no, name, base_price FROM ordered_lst
I will run the form the first time, and everything seems fine. I can then quit and restart the form with a new data set. The grid will still be displaying the first data set. I can see that the cursor is correct with a browse command.
I've tried putting a THISFORM.refresh in the page refresh.
How do I get the grid to purge the old data set & refresh itself ?