>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.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)