Is there a good reason why you cannot use a view instead? Then you would just requery with it any time to bring across the any updates. You alias would be the view then everything else stays pretty much the same.
>Hi
>
>I am building a tiered application with VFP, and the presentation layer is thin. All data is sent in batches as and when needed. This means that occationally I need to update the data in a grid.
>
>I used RecordSourceType = 1 (Alias). However, if I close the table, repopulated it and open the table again, the grid has by now become empty, and all the columns disappeared.
>
>I created a small routine in Init that saved values such as columnCount and the ControlSource of each column, and reset all values back to what they were before the table was closed. This resets the columns OK, but no data is displayed. Is there any way I can get the grid bound to the table again to display the new data?
>
>Would be grateful for some help.
>
>Steven Edge
Mathias Banda
Time is longer than a rope.