>>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()

yes i tried grid1.refresh(). guess the problem i am having is that when recordsource = "" the grid loses its column controlsource. the client can see the incorrect data in the column. there are actually several hundred lines of code between the recordsource = "" and the the recordsourcetype = 1. modal screens are displayed, but they do not fully cover the grid. i am trying to preserve the look of the grid until i can removeobject("grid1") and then
addobject("grid1")

thanks - brenda