>José,
>
>Ecolo is divided in 22 sites. All sites need the same database. I try to do connections from Charleroi to Namur. The server is in Namur. In Charleroi, I have only a PC with modem. The problem is that with only VFP, when I have my connection, I send my request (SQLExec()) and the server don't execute it but send me all the tables who's are in my request.
>
>For example, I want the name and the firstname of a people in a table who has the number 25838 and the server send 6Mb.
>
>Stef

So you need two things. A connection, that seems to be working. And a way to retrieve your data. Either SQL passthrough or a Remote View.

Let's say you want to retrieve by searching the name, the remote view would be coded this way:

CREATE SQL VIEW [ViewName ] REMOTE
[CONNECTION ConnectionName [SHARE]
AS SELECT * FROM myTable WHERE cName = ?vp_cName

Don't forget to define your parameter(s) under the menu Query/ View Parameters.

José