Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Grid on form won't refresh
Message
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Title:
Grid on form won't refresh
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00954415
Message ID:
00954415
Views:
52
I have a grid on a pageframe on a form that displays a cursor. When the page it is on is activated, I rebuild the cursor and refresh the grid. But I do it by populating a "temp" cursor via a SQL statement, then zapping the cursor that the grid displays, then appending from the temp cursor. Unfortunately, the grid will sometimes show no data. All the columns are blank. If you click off that page and then back to it, it will display properly. Also, for testing, I put a button on the page that just refreshes the grid and if I click the button, then the grid will refresh and I can see the data. I've put refreshes all over the place (again, for testing) and even a DOEVENTS or two, but still this occurs.

I've also used the technique of changing the RecordSource of the grid to a cursor with the exact structure, saving the control sources of the columns, zapping and repopulating the main table, setting the RecordSource of the grid back to the main table, and restoring the control sources of the columns, all to no avail.

I should probably just change this to a view, but I use this technique in other projects without difficulty and it's irritating that I can't get this grid to display the data properly.

Russell
eCost.com continues to rip people off
Check their rating at ResellerRatings.com
Next
Reply
Map
View

Click here to load this message in the networking platform