>>>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
>>
>>You should not be dependent on VIEWS for C/S application. Consider SPT which have some advantages over VIEWS, and also buzzword about ADO. It is true that using VIEWS to manipulate data is more complex in the sense because you have major changes in code other than native VFP DML but you are in the right track in achieving C/S technology.
>
>What do you mean by SPT?

SPT - SQL PASS-THROUGH: A query you can use to work directly with tables on a server which understands a dialect of SQL different from the one processed by the client application. You can use a pass-through query to return a snapshot of rows or execute non-row returning commands.