Alan, >The requirement is to update VFP tables from an XML source. However, I can't get the XML into VFP natively. XMLTOCURSOR(), XMLAdapter, West Wind ... none of them work, they all die with the same error to do with code pages.
Have you by any chance posted the problem over on the UniversalThread? Aleksey from Microsoft regularly responds to XMLAdapter questions there and he would know if it can be made to handle your codepage problem. I do know that VFP9 got a good many changes related to codepages. Because Aleksey wrote XMLAdapter, if he says it can't be done, then it can't. > (1) Write a COM DLL in .NET with an interface that can be used to extract data that VFP can work with. Or maybe just to render all the nested tables in the DataSet to seperate flat XML files that VFP *can* understand. VFP9's XMLAdapter can usually handle a multi-table DataSet automatically with no problems, as long as it has a complete schema with data type and precision (you have to set the .NET MissingSchemaAction property to AddWithKey to get a complete schema, at least in earlier versions of .NET -- see details in Rick Strahl's article about .NET/VFP data exchange). > (2) Write a little Windows Forms EXE that just takes the XML and populates the VFP tables via OLEDB. That should work too, although you'll still have to be sure you get the OLEDB driver installed on each computer, in addition to the Winforms app and correct version of .NET framework if not already there. David Stevenson -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.394 / Virus Database: 268.9.2/373 - Release Date: 6/22/2006 _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
