Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Send recordset to server
Message
General information
Forum:
Visual FoxPro
Category:
Internet applications
Miscellaneous
Thread ID:
00258288
Message ID:
00258458
Views:
12
Erik:

It appears you can also transfer XML data as strings from client to server and back through HTTP using the RDS Dataspace control. Using client side script, I can call methods on my VFP COM object that run queries and return XML strings. I then load them into the XMLDOM on the client using the LoadXML() method. From here, you can bind them to the XMLDSO and work with local data using ADO commands. When I want to update the server, I use the XML property as a parameter and call my update code on my VFP COM object. In the update method, I use the XMLDOM to walk the XML tree and convert XML string to cursor. Then I loop though and update the database.

The great thing about this setup is you can cache data on client and minimize network traffic by limiting round trips to the server. Also, your taking advantage of what VFP is famous for, that being local data crunching and string processing. I haven't tried this out in an application but I have built a proof of concept demo on my machine running PWS to simulate an internet environment. Works like champ!


Charlie
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform