>Hi All,
>
>I cannot find anywhere a discussion on the relative merits of :
>
>- Using the Data Environment to open all required files
>- Coding the Opening of files
>- Using Table Views.
>
>Any ideas, or any article one can refer me to ?
>
>Thank you.
>Michel Creppy.
Michel,
Briefly, Table Views should be used if you're planning to upgrade to Client Server during the lifetime of the application, and if you have a lot of lookup tables where the user needs to see the 'description' value from the lookup. Parameterized views are particularly useful in child-grids and other parent-child relations.
I also use views where I'm using the same SQL code in multiple forms
My personal preference is to use the data environment to open tables and set the initial indexes. If I need to set relations I do it programmatically. I like being able to check all my tables without walking through a lot of code, but I have had problems (particualarly in VFP3) with relations set graphically.
JMHO,
Barbara