I assume you mean Visual FoxPro. I can only consider C# solutions. In fact, my company is switching from VFP to C# largely to address performance problems between VFP and MS SQL 2000. I assume that there is a optimal method in C#.
>Use a vfp COM object to query and process the data or feed the data into a local instance of MSDE/SQL server... There even is an article by Kamal Petal (Kemal Patal ? I am getting old) on using vfp to query .Net Datasets AFAIR.
>
>HTH
>
>thomas
David S. Alexander
Kettley Publishing
20271 SW Birch Street, 2nd Floor
Newport Beach, CA 92660-1752