Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
XML -DOM
Message
General information
Forum:
Visual FoxPro
Category:
Internet applications
Title:
Miscellaneous
Thread ID:
00362646
Message ID:
00363535
Views:
39
>>>>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)  && Load as XML document
>
>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.

My question is to load up the XML Record Set into ADO
Does ADO need to use MSXML

I know that your class creates the XML without the use of MSXML but does ADO need it to create the record set?
Charles

"The code knows no master." - Chuck Mautz
"Everybody is ignorant, only on different subjects." - Will Rogers
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform