>How do I use an SQL table from Foxpro???
>
>I am able to connect and setup a View, but I have to build a select statement that narrows down to one (or a few) records in the SQL table. If I just try to "open" the SQL table, it will download *ALL* of the table and can take MANY MANY minutes. SO my view just gets the ONE record I want, but to go to another record, I must close the view, change the select statement memory variables and open the table again. It is literally 100 times faster to use Foxpro on a copy of the SQL table, but I need to use teh real SQL data.
>
>HOW DO I OPEN A SQL TABLE????
>
If your goal is to pop the entire database into a browse, and scroll through it, you're in for a rude awakening - that's not what VFP acting on data in a backend is designed to do.
Operations through a backend are designed to have the data reside and be managed from the central server; requests are passed to that server, performed on the server, and the resutls are passed back to VFP through one of several mechanisms. Rather than performing file-level operations to read and write raw data for processing by the VFP application, backend databases work by passing operational requests to the server and having them processed there, with a minimum of data moved between the server and VFP to accomplish the relatively narrow operational requirements of the application that are scoped by the requests sent to the server.
Essentially, you need to rethink the manner in which you work with the data, in the same way that you had to rethink using VFP native data to use local views and the results of queries against the native database.