>>>Third Question: I have been to west=wind.com and Rick has a wwXML class that create a XML that can be used with ADO. Do you have the have IE 4.0 or higher to use XML with ADO?
>
>It requires the IE5 version of the msxml.dll to be installed. Note the IE5.01 version needs to be downgraded because of bugs. There's an article on Rick's site about it.
Actually that's incorrect.
wwXML's output doesn't require any system components - neither msXML, nor ADO.
But in order to use the output from CursorToADOXML() method you have to have ADO 2.5 which is the only version that knows how to deal with XML based recordsets.
FWIW, I've added a CursorToRS method to wwXML which uses this output and creates a recordset. It's faster and more reliable than the CursorToRS that comes with VFPCOM.
lcXML = THIS.CursorToADOXML()
lcFile = SYS(2023) + "\" + SYS(2015) + ".xml"
File2Var(lcFile,loXML.EncodeXML(lcXML))
oRS = CREATEOBJECT("AdoDB.RecordSet")
oRS.OPEN(lcFile)
ERASE (lcFile)
RETURN oRS
Also new (but not released yet) is schema support for data typing of cursors and objects, which can also help tremendously in parsing as the XML content can be returned in their actual datatypes skipping the text->type conversions.