>Where does the SQL Statement Actually execute?
>
Terry,
The VFP data engine is the VFP data engine whether you use VFP or ODBC... As you found, even with the VFP ODBC driver the client machine still does the processing.
Of course, if you use the SQL Server ODBC driver, and passed the SQL to it, the SQL Server would process the query and return the results.
If you used the Jet Engine Database it would be done on the client.
If you used the ORacle ODBC driver it would be done on the server. ODBC doesn't necessisarily mean C/S.
OF couse there is a way to use VFP on a remote machine to precess your request and return the results. This is basically a move to n-Tier. See
www.west-wind.com for an article on Distributed VFP Aps over HTTP.
BOb