>Hello,
>
>A view is created in the database Joining two tables, Now the view is updated automatically when I am appending the records in respective tables from the command box.
>
>But I am appending the records in the respective tables from the form but my grid of view is not refreshing. I came to conclusion that the view gets refresh only after
>
>dataenvironment.closetables() and dataenvironment.opentables() are issued, for which I have to close the form and re-load it. which is impraticle.
>
>Is there any better solution to update the view with closing the tables.
>
You can REQUERY() the view once the base table has been updated; make sure that you've issued TABLEUPDATE() to post changes into the base tables before issuing the REQUERY().
>
>Thanks and Regards
>Rajesh