Ok, That sounds great ! I have VFP 9 but have not yet created any exe's or even really worked with it due to my schedule....
Thanks for you r reply !
>Greg,
>
>>Is it possible using the xmlAdapter Class to output heirarchal XML from vfp cursors (or tables) such as something like this ?
>
>VFP9's XMLAdapter added considerablely to the features for Hierarchical XML and can nest one table's records inside another table. You have to have the tables open and related to each other first, then you can use code like this from a Microsoft sample:
>
oXA=CREATEOBJECT("XMLAdapter")
>
>oXA.RespectNesting=.T.
>oXT=oXA.AddTableSchema("foo")
>oXT.Nest(oXA.AddTableSchema("foo1"))
>oXT.FirstNestedTable.Nest(oXA.AddTableSchema("foo2"))
>
>oXa.ToXML("hierxml.xml",,.T.)
I have not tried it with persistent relationships in a DBC, but it does work with SET RELATIONS. I don't know of a way to handle this with XMLAdapter in VFP8.
Greg Foote
Software At Work, Inc.