>Hello all
>
>I'm just exploring my options to use the View in all my forms,is it a good practise to use views in forms,does it improve performance,what is the advantage of having views over tables in Dataenvironment of a form and good examples to learn more about updatable views in forms
>
>
>Thank you.

Views do create a litte additional work for the programmer. I use views in parent-child scenarios, when the child grid has to filter out records (all records corresponding to a certain parent), and when the child table has a total of > 20K records.

It seems VFP doesn't use R.Optimization correctly when you combine a grid and a filter.

With a view, you would use a view parameter.

A view is simply a query that is updatable. Of course, some additional considerations apply. But better experiment with the view designer, and then ask back.

HTH, Hilmar.