Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Managing deleted records
Message
From
20/11/1998 13:39:15
 
 
To
20/11/1998 13:25:17
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00159815
Message ID:
00159862
Views:
28
OK, I see now why you have to reinitialize the grid's record source. It's not because of the pack, but because you had to close the table the grid is based on to open it exclusively afterward. You must reinitialize the record source of the grid each time the table is closed and reopened. You have the same behaviour if the grid is based on the result of a SELECT-SQL and you reissue the query.

I would suggest closing all forms before starting the pack process. This will also mean that you will need to put the function elsewhere than in the same form of the grids.This method will save you the pita of reinitializing every grid.

HTH

>The only thing I still wonder is that you say I don't have to reset the record source on a grid after packing a table. My experience is that the grid shows up blank on the next refresh if I pack the table. Is there some setting that I don't know about?
>
>Some more about the context...it happens on grids that contain explicit columns (the column record source also seems to be nixed) and I do the pack via a command button on a different page (in a pageframe) than the page containing the grid. When I go back to the page containing the grid, the grid is empty. If, after the pack, I reset the control sources for all the items in the grid, it's fine.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform