Hi,
I have been using VFP6 for two years to make an application where the VFP6 database resides on the server and the client app accesses it via ODBC (to allow dial-up if necessary). I have posted these questions to other forums but I'd like a response from this one because we seem to have a continuous misunderstanding. It would also be helpful if someone points me to a Microsoft article or official document that clarifies this.
1) When a parameterized <b>remote view</b> is opened, is it that the <b>entire</b> base table is loaded to the client machine and the parameterization happens on the client side because of the fact that we are dealing with flat files?
If this is true, then we can't really making an efficient app using ODBC. The only way to avoid this, is to have a backend database that is not based on flat files, e.g. SQL Server, Oracle
Gracie
©2002 Grace McCalman |
