Craig, thanks for the replies. Let me make sure I understand. Are you saying that regardless if I use a "view" or "PT" - in both instances - the query is passed to the back-end server for processing in the same way? If so, I must have gotten very confused at some point because ....

I was under the impression that when you run a VFP view, the 1st step is for the back-end server to send only index info to the VFP data engine from which VFP then determines the records it needs based on the index info provided by the server and then re-send the SQL statement requesting only the needed records based on data it had read from the index info. Thus, the VFP engine was doing much of the selection work on the local workstation and because of the first step of sending the index info to VFP, you were increasing the traffic over the LAN/WAN.

Futher, I thought that I had heard (or read) that by using SQL Pass-through you eliminate the first set of sending index criteria to VFP from the back-end server because your are sending the "packaged" SQL statement to the server for it to process. Since all of the processing is done by the server data engine and only the requested records are sent back to VFP, you limit the traffic across the LAN/WAN.

If I am totally confused on this issue, let me ask it another way. Does a view vs. a PT statement generate the same amount of traffic accross the network?

Thanks for helping me sort out the differnces between views and PT.

Robert Wright