Hi!
thisform.Grid1.RecordSource = ""
thisform.Grid1.ColumnCount=-1
thisform.Grid1.RecordSource = "NewAlias"
No need to re-assign control sources, tehy're assigned automatically. The grid is reconstructed though, so to have some functionality in it you might be interested in VFP Grids articles in the August and September UT magazines on this site.
HTH.
>It was recommended that to keep a grid from crashing when I delete the table's records and refill them with new ones... I should:
>- use COPY STRUCTURE to create a temporary file with proper structure
>- change the grids RECORDSOURCE to the new structure
>- change the grids columns CONTROLSOURCE to the new structure
>- change the delete the old source file and recreate the data
>- change the grids RECORDSOURCE to the recreated file
>- change the grids columns CONTROLSOURCE to the new structure
>
>How do you change the CONTROLSOURCE... I tried thisform.grid1.columns(1).controlsource= and I get an error of unknown item.
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.