Josh,
thanks a lot I'm fairly new to views as you can guess and I've recently rewritten an application using views wherever possible, the ease of system maintenance in comparison to the old relational way is amazing and performance, if anything is snappier, I don't think MS really promotes local views enough in there documentation of VFP, as Client server is not as popular in this country as maybe yours, we tend to think views = CS
thanks again
Pete Kane


>Ah, now I get it. No. Unless you use a server database like SQL Server, Sybase, or Oracle, everything happens on the local machine. This is true even if you access the VFP tables through ODBC.
>
>>Josh,
>>I didn't make myself clear, what I mean is , do local views work the same ( basically )as say SQL server where the Query is run on the backend server as opposed to the local machine
>>Regards
>>Pete Kane
>>>I'm not sure I understand your question, but the SQL statement in a view is executed when you USE or REQUERY() the view.
>>>
>>>>I have an application which although runs locally accesses data from a server, I have a number of local views in my database, where are the stored SQL statements executed?
>>>>TIA
>>>>Pete Kane