I was amazed the first time I had to access SQL Server Data thru ODBC. This was several years ago. I had heard all the Fox folk tell me how great fox was. I had some reports running off of DBFs downloaded from an AS/400.
Much to my surprise, when I pointed to reports to cursors created thru SPT, the reports ran noticably faster.
PF
It is not as intantaneous as you think.. As for SQL, only the result set comes back. And, if I want, I can operate asyncronsously... You really don't want to take me on here... But if you must, please do....Also, this thing you allude to VFP caching data on the OS level. Could you go into that further. Do you mean the client or the server??
>
>And, FWIW, SQL Server can cache data as well. However, those caches are on the server.... Once again, you really don't want to take me on here....
(On an infant's shirt): Already smarter than Bush