Hi Y'all,

The following string does indeed get converted to a cursor via XMLTOCURSOR() but in this case, I only get one record and it holds the value of the last entry in the XML string (Initial Documentation); I cannot figure out why it does not give me a cursor with all the records in it. The line used to convert the string is:

XMLTOCURSOR(lcXMLData,tcCursorName,4)

where tcCursorName holds "CorrespondenceTypes" and lcXMLData contains the following string. Can anyone figure out why it is not parsing correctly? (VFP7 SP1) Can anyone else get multiple records if they run it?

(bummer...just found out I cannot paste in an XML string with the brackets around it - I had to substitute and opening triangle bracket with a an exclamation point and a closing bracket with a tilde. YOu will need to convert back to run it - sorry, did not know how to upload otherwise).

!?xml version = "1.0" encoding="Windows-1252" standalone="yes"?~
!VFPData~
!correspondencetypelist~
!correspondencetype~Client Services!/correspondencetype~
!correspondencetype~Post Funding!/correspondencetype~
!correspondencetype~Funding!/correspondencetype~
!correspondencetype~Work In Progress!/correspondencetype~
!correspondencetype~Future Care!/correspondencetype~
!correspondencetype~Meds and Rateups!/correspondencetype~
!correspondencetype~Initial Documentation!/correspondencetype~
!/correspondencetypelist~
!/VFPData~

* the data is being retrieved from a DLL supplied to me.

Thanks,
Albert Gostick