Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP as server
Message
From
03/11/1999 08:43:19
 
 
To
03/11/1999 07:14:57
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
Miscellaneous
Thread ID:
00285988
Message ID:
00286027
Views:
24
>>VFP is natively a server. There are loads of threads here which have covered this topic. VFP's own documentation and samples provide you with examples of VFP being a server.
>>
>>If you have more questions after this, do post it here.
>
>VFP is definitly (how do you spell this word ??) NOT a server. Want I want is pass an SQL command to some process (written in VFP or whatever) that returns the results which it got from some VFP tables (in 2 words client-server).
>
>Let me explain : I want to exchange data (on record level) over an ISDN RAS line. As only opening (USE) a table over RAS takes from 30 secs to a minute or even longer, I want another approach : send the SQL over the RAS line (in a fraction of a second) and wait for the result.

Pascal,

I'm not going into a debate with you about whether or not VFP is a server. I know it is, you believe otherwise.

However, to answer your query, in the C/S environment you have mentioned, you can use VFP's native SQL passthrough commands from your client side (you will be required to use use ODBC connections) into the server side VFP tables which will process your request, and return data to you in your designated cursor.

If you do not want to use ODBC, you can use ADO as well to return your record sets.
Sanjay Kapoor

Relatively speaking is a conversation with Einstein
Previous
Reply
Map
View

Click here to load this message in the networking platform