>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.
Sarah,
After you delete the records issue Requery("TheView") using the view's alais name and then refresh the grid.