>Let me explain this question :
>
>I want to access a VFP database over a RAS/ISDN connection which means slow speed. So I was wondering : if I could send an SQL command over to the remote side, processing is done at the remote side and not over the RAS connection, an the result is sent over, the connection wouldn't be charged for processing, only for exchanging the data ...

Sure... it's possible... Actually, a project I am working on the side is just that... I call it VFPServer. It will allow you to pass SQL and it will return the result set... or if you put the DBC on the remote and the server side it will use the information in the view to do queries and updates. I also plan to write a client side class that will simplify accessing it... and also convert the data passed back into a cursor.

The second release may even allow you to use a DE by pulling all the info from a DE, passing it to the VFPServer for it to send the data, then putting the info into client side cursors, the form would never know all this happened.

Only thing am not sure I can capture a tableupdate, so you may have to send commands to my class to save the data.

I kinda put it on the side, since I was waiting for SP3 for the session class, and also for the runtime compile so I could support stored procedures. Also, the mutli-threaded runtime will allow for multiple request to process at the same time... Other than that, I was thinking of using FoxISAPI as a pool manager for single use EXE's.

Also, using FoxISAPI should allow accessing it over the internet/intranet where the user would need an account in the NT domain.

I see a great advantage to this for people that want to do ClientServer using VFP on both ends... Also, you could secure the data from the user, since only the server need have access to the data files.

Interested in Beta testing?

BOb