We have recently upgraded West Wind Web Connection from version 5.68 to the latest 8.x version.
Our application uses Web Connection to synchronize tables between different FoxPro database instances.
The client application is quite old and still uses the wwXML.vcx class from around 2006 (attached code).
The Web Connection server, however, has now been upgraded to version 8.x, including the xmldl.pag code on the server side.
The client code creates a wwXML object and uses LoadUrl() to retrieve XML from the server, followed by Xmltocursor() to convert the XML into a FoxPro cursor:
owwXML = Createobject("wwXML")
lcXML = owwXML.LoadUrl(This.csyncurl+[/xmldl.pag?LastGet=]+lcLastAuditID+[&Site=]+Transform(This.nsiteid))
If lcXML = "_FAILED"
Replace endtime With LocalToUTC(Datetime(),This.ntimebias), success With .F., Note With "Nothing to Download" In synclog
llBatchesComplete = .t.
Else
owwXML.Xmltocursor(lcXML, "XMLdl")
If !Used("XMLdl")
Replace endtime With LocalToUTC(Datetime(),This.ntimebias), success With .F., Note With "XML Conversion Failed" In synclog
My questions are:
Is the old wwXML.vcx class compatible with Web Connection 8.x?
I cannot find wwXML.vcx in the current Web Connection 8.x distribution. What is the current replacement for this class?
Is wwxml.prg the intended replacement?
Are there any changes to LoadUrl(), Xmltocursor(), or Cursortoxml() that we need to make when upgrading from the old wwXML.vcx to the current implementation?
In particular, is there any reason why XML generated by the 8.x server would not be correctly handled by the old wwXML.vcx class on the client?
Any advice on the recommended migration path would be greatly appreciated.
Yes wwXml.prg is the replacement for the old class. You can do the following:
SET PROCEDURE TO wwXml.prg ADDITIVE
loXml = CREATEOBJECT("wwXml")
lcXml = loXml.LoadUrl("https://somesite.com/xmldownload")
Wherever you were using SET CLASSLIB TO wwXml ADDITIVE replace it with SET PROCEDURE TO wwXml ADDITIVE. If you're using NEWOBJECT() then you'll have to explicitly reference the PRG file.
+++ Rick ---