reload grid source (view)?

[tonedef]

I have a form which contains a pageframe. Each page of the frame has a grid to display a different 1 to many relationship with the table that is on the main form (outside the pageframe). I am not allowing any editing of the grids. When the user double clicks the grid another form opens to edit that data. After editing the data and closing the form I would like the grids on the original form to display the correct data. The source of both grids is an alias from the forms dataenvironment. One is based on a table the other a local view. The one based on the table works exactly as I would like. However the one based on the view does not update until I close the form and come back in. Is there a way to get the view to requery so that the data is updated in the grid?

Thanks,
tone

 

[DSummZZZ]

Are you saying the REQUERY statement doesn't work?

Dave S.

 

[tonedef]

there is no requery for a grid or a cursor in the dataenvironment.

tone

 

[DSummZZZ]

No, but there is a REQUERY() function call for views. You should be able to call it in a refresh or activate event.

Dave S.

 

[tonedef]

Thanks Dave,

As a note to anyone else who is reading this thread. For the requery to work your view can not be read only.

tone