>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,

I control the opening and the management of my tables programmatically. I have found that the additional coding is negligible compared to the incomparable flexibility this approach allows. Conceptually I find it unnatural to let the form manage accessese to the database, practically, the least I have to do in the form designer, the better I feel :), and finally my forms are classes (.VCX) not screens (.SCX), so they do not own a dataenvironment.

As for views, up till now I have not yet felt the need to create them. The same reasoning as above holds for the database. I'd rather find sql's back in my code than have to rely on the database. Do not forget that sometimes :) you have to debug your work, and then the advantage of the programmatic approach proves the only one viable, when compared to the necessessity to go and open several different tools.

Yes, you could say that when in doubt I take the programmatic approach.

Kind regards,

Marc