Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Wishlist???
Message
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Miscellaneous
Thread ID:
00260725
Message ID:
00261599
Views:
39
>I want to be able, in the native VFP language, to have a SQL statement processed by another workstation and have the result-set returned to the issuing (of the SQL statement) workstation as a normal and regular cursor( or perform any updates or deletes, depending on the SQL statement issued). A VFP-Server, if you will, talking with VFP clients. No ADO, no ODBC, no SQL-passthrough, no anything fancy. Sure, maybe some new SET command or two, and/or maybe some new clause(s) for USE command, but that's about it.

You'll never see that in the language.

However, you can do that today with Web Connection over the Web... where the
Web could be an intranet working on the machine sitting next to you.

The wwHTTPData class will return a Fox cursor to you using Syntax very similar to SQL Passthrough running the query on the Web server. You can try this yourself with an online demo at:

http://www.west-wind.com/wconnect/wwHTTPDemo.app

The demo is an ActiveDoc, so you need IE4 or later and VFP6 on the machine
to run this demo. FWIW, this demo contains a number of other client side
demos talking to a VFP Web server, including several XML data examples.
+++ Rick ---

West Wind Technologies
Maui, Hawaii

west-wind.com/
West Wind Message Board
Rick's Web Log
Markdown Monster
---
Making waves on the Web

Where do you want to surf today?
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform