I have tried using the CA builder with XML created via CursorToXml but also with no success.

Am I correct in believeing that the "SelectCmd" property contains the name of the XML file?
If not where do I specify it?

Regards
Geoff Scott

>What did you try and why?
>
>>
>>I have tried this and am not getting any cursor. Any ideas why?
>>
>>Regards
>>Geoff Scott
>>
>>>Hi Mark,
>>>
>>>Try

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()
>>>

>>>
>>>>Let's say I have an XML file that looks like:

>>><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!