Stephen, >It's been a long time since I did any XML from VFP. Can VFP pull schema and determine that there is a small combination of tables in an xml file? Or do you have to parse that out yourself?
VFP's XMLAdapter can handle it if the schema isn't too complicated. In general, anything output from DataSet.ToXML can be read by XMLAdapter, including multiple tables. However, the MissingSchemaAction=MissingSchemaAction.AddWithKey setting is needed on the .NET DataAdapter to be sure it sends field lengths and precision in the schema -- at least in earlier versions of .NET (haven't tried in 2.0 yet to see if they changed the default setting to actually include that info). If you don't change that, the XML output by DataSet has a "brain-dead" schema that results in all fields becoming Memos in VFP cursor when XMLAdapter reads it in. Alternatively, you can set up a schema programmatically in XMLAdapter to work around the problem. But back to your question, yes, VFP XMLAdapter can handle multiple tables in the same XML if it has a schema to use in interpreting the data. XMLToCursor cannot handle more than one table, but does not require a schema (makes a best guess on field type, length and precision unless you use 8192 flag to direct the data into an existing pre-formatted cursor). David Stevenson [excessive quoting removed by server] _______________________________________________ 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.
