Hi Jim. I pulled some articles about using VFP for Remote Automation. In the examples, they assume you want to use the automation server with products other than VFP, so they use long character strings to transfer records. These strings will then be parsed and used by the client.

If we assume that the automation server will only be used by VFP clients, and therefore VFP tables will be readable by the client, do you know how record sets can be passed back to the client in VFP table format?

Thanks.


>
>This is certainly the best way to provide scalability. When you move to SQL Server you onle need to change the VFP Server, the interface doesn't have a clue where the data is comming from. It sks the server for data and the server gives it the data it asked for, the interface knows nothing about where the data is comming from. Using a VFP server this way is true N-Tier system design.