1435 - XML Parse error : Invalid at the top level of the document Line 1, Position 1. e:\alpha\test.xmlI am trying to figure out cursor adapters with an XML files
oCA = CREATEOBJECT("CursorAdapter") >>>oCA.Alias = "TestXml" >>>oCA.DataSourceType = "XML" >>>oCA.CursorSchema = "oldsku V(10), newsku V(10)" >>>oCA.SelectCmd = "test.xml" && The name of memo field >>>oCA.CursorFill(.t.) >>>... >>>SKIP IN test >>>oCA.CursorRefresh() >>>>>>
>>><snip>>>>>>The VFP Help file is not very helpful in examples for either using the XMLAdapter or a CursorAdapter with the DataSourceType set to XML. What I need to do is be able to load this XML into a cursor for display purposes only. This XML data is in the memo field of a VFP table, so as I skip through the records, I would like to "reload" the adapter with the new data from the XML information. This will all be read only so updating will not be necessary. I do not particularly want to go the XMLTOCURSOR route if possible as I think a "CursorRefresh" would be more efficient. I would also like to specify the cursor schema to be V(10) for both of those fields. TIA!