>I dont have VFP 7.0 yet (on order, but government purchases are real slow). What I need is a volunteer to take a table, which I will zip up and email to you, to create an XML stream. Which will then be zipped back up and emailed back. I dont know what type of XML VFP 7 can create, but if an XML with schema can be created or headers that would be good. Maybe who ever volunteers can send me a few zipped files of what different XML streams VFP can create. Just trying to see if we can get our VFP data to a Web Tool called LiveLink.
>
>Note your email needs to be able to handle a 1.6MB file.
Just a word of warning: VFP's CURSORTOXML() is fairly limited in waht you can do with it. Yes it will generate valid XML with a schema but XMLTOCURSOR() will only import data of that same format including a schema! Without a schema VFP will try to guess at the structure to create a cursor for you and it doesn't guess so well.
The problem here is that the schema a) is not used by any shipping software (it's the .Net beta 2 single datatable of a dataset schema) b) can't be made to fit any other data. This includes importing data from SQL Server generated by the XML extensions which don't work either.
I was pretty bummed about this because this really means that the XML import features only work with data that was generated by VFP in the frist place. The speed would have been nice for a number of things, but with these limitations it's not terribly useful.