I try using xmlAdapter to import XML file something like picture attacted below :


?xml version="1.0" standalone="yes"?
DATAPACKET Version="2.0"
METADATA
FIELDS
FIELD attrname="DOCKEY" fieldtype="i4" required="true"
FIELD attrname="DOCNO" fieldtype="string" required="true" WIDTH="20"
FIELD attrname="DOCNOEX" fieldtype="string" WIDTH="20"


p/s I remove the "< >", because forum not allowed, can see code in the attached picture.


ad = CREATEOBJECT('xmladapter')
ad.LoadXML(cfile,.T.)
ad.LoadXML('inv.xml',.T.)

but ad.tables.count = 0, means nothing is imported

i also try XMLTOCURSOR, but hopeless also.

anybody can help?

thx