Koos,

If you expect to move to client/server you will want to avoid doing things like using tables and setting filters on them or browsing the whole table. In addition to using views you can also use SQL Pass-through with a client/server system. This allows you to send SELECT and other SQL commands directly to the back end. You could write your VFP apps using SELECTs then port them to SQLEXEC() later. I wrote a function that I pass the SELECT command to. It just returns the command to the calling program which runs it using macro expansion. You could then modify the function to return a SQLEXEC() command when you move to c/s. You should try to avoid using VFP functions in your SELECTs as they probably won't work in a c/s system.

>Hi,
>
>We are trying to use views for all our tables because we want to have all our apps more prepared for a possible migratio to a client/server environment. Unfortunately we encountered that with view you loose some possibilities you have with working direct on the VFP tables.
>We now are doubting and considering to go back to working direct on the VFP tables. Can anybody cast some light on our discussion.
>Should we learn more about views and should we be able to do everything with them ? Is it indeed easier to work direct on the VFP tables ?, what is better ?
>
>Koos Veel