>i execute a procedure which does a CREATE VIEW TO filename and then a SET VIEW TO filename. after the SET VIEW my grid is blank. i believe it does a create view because later it will close all the databases (have not executed that far into the logic yet).
>
>have read int ut to try the following, which i did:
>
> grid1.recordsurcetype = 0
> grid1.recordsource = ""
> set view to filename
> grid1.recordsourcetype = 1
> grid1.recordsource = "table1"
>
>the recordsource = "", immediately loses my column controlsource. and then the set view still blanks my table.
>
>any suggestions would be appreciated. also, why does everyone on ut suggest recordsource = "" ? it does not allow your grid to keep its column controlsource, text formats, etc.
>
>thanks - brenda

Have you tried refreshing the grid with grid1.refresh() after setting the recordsource to what you want it to be? Such as:

grid1.recordsurcetype = 0
grid1.recordsource = ""
set view to filename
grid1.recordsourcetype = 1
grid1.recordsource = "table1"
grid1.refresh()