>Hi John,
>
>my first idea was to set loXmlAdapter.Tables[1].Fields[n].XMLName, but this property is read only. How about renaming the fields of your cursor in advance?
>

>SELECT FieldName1 AS XmlFieldName1, FieldName2 AS XmlFieldName2 ;
>  FROM c_empllist ;
>  INTO CURSOR c_empllist_for_xml
>

>
>HTH,
>
>Markus

Markus,
great idea except that I don't think I can have field names that long plus the element names are case sensitive. The only thing I have come up with so far is to do it myself with textmerge(). I wrote a little prg to strip the element names out of the XSD file into a VFP table. I can then add the field names from the cursor to the table records then generate text from the table records. The resulting text string can then be processed within a scan loop using textmerge to produce the xml output. It will take some tweaking but I think it should work.

I was just hoping there was a (much) easier way.
Many thanks for the idea though,
John.