How do you expect to have a cursor with multiple columns named the same 'service'?
Anyway, a two cursors/XMLs seems simpler to implement. I don't see what nesting of the objects in XML gives you. If you still want to go that road, check
http://www.berezniker.com/content/pages/visual-foxpro/using-xmladapter-create-and-load-nested-xml>Hi all, I'm at my very first approach with Xml and I'm not sure i really need to use it :)
>
>I have this problem
>I neeed to record the setup of an object which contains other objects having their own properties.
>I have a main table whiche refers to the setting of specific clients CFGT (idt c(10),prop M)
>
>inside the Prop Field I want to store all the settings of the client
>It is simple if the client contains a single object but what if it is populated by many objects each of them having its own properties ?
>
>I thought about a XML but I have problem with the two dimensions
>
>here is a short example of what I should do
>
>
><MainObject>
> <BackColor> </BackColor>
> <NumberOfControls></NumberOfControls>
> <Mode></Mode>
>
> <Control>
> <Name>control1</Name>
> <service> xxx </service>
> <service> yyy </service>
> <service> zzz </service>
> <position> 1 </position>
> <mode> </mode>
> </Control>
> <Control>
> <Name>control2</Name>
> <service> xxx </service>
> <service> yyy </service>
> <service> zzz </service>
> <position> 2 </position>
> <mode> </mode>
> </Control>
> <Control>
> <Name>control3</Name>
> <service> kkk </service>
> <service> jjj </service>
> <service> hhh </service>
> <position> 1 </position>
> <mode> </mode>
> </Control>
>
>
></MainObject>
>
>
>what i want to have back are two cursors one which the MainObjectproperties and the second with the rows of the various controls
>is it possible ? Or should I use two different structures ?
>
>thanks
>Alessio
--sb--