I have a read only grid based upon a view (I needed some memo fields truncated and displayed in text boxes). Users can delete the records from the table by clicking on a delete button which uses SQL Delete to delete the record and it's children. I then do a grid.refresh().

The refresh however doesn't update the view.

If I try and delete from the view I get an error. If I try and make the view not readonly I am told I have to reload the data environment. Great! but how do I do this.

What is the best practice in this situation?

Thanks
Sarah.