When you use a view with NODATA (or NoDataOnLoad in the data environment) VFP sends a request similar to this to SQL Server:
SET FTMONLY ON
select myfields from mytable
SET FMTONLY OFF
SET FTMONLY is a SQL Server command.
You can use SQL Server profiler to see this. Just fire SQL Server profiler, then go to VFP's command window and open a view with NODATA. Then, go to the profiler and see what VFP sent to SQL Server.
>I’ve been using parameterized views extensively in order to accelerate the process or retrieving data from large record sets.
>
>What I’ve always wondered is, how much from the base tables is really being transmitted and/or opened through the network, since even if you open a parameterized view with NoDataOnLoad = .T., you can always browse the base table without waiting for a significant amount of time.
>
>I’ll appreciate any kind of information regarding this.
>
>Regards
>
>Oscar Corte
Hector Correa