>- <xs:complexType> >- <xs:sequence> >- <xs:choice> > <xs:element ref="QUARTER" /> > <xs:element ref="MONTH" /> > </xs:choice> > <xs:element ref="YEAR" /> > </xs:sequence> > </xs:complexType> >>
>either > ><PERIOD> > <QUARTER>1</QUARTER> > <YEAR>2007</YEAR> ></PERIOD> > >or > ><PERIOD> > <MONTH>3</MONTH> > <YEAR>2007</YEAR> ></PERIOD> > >Is this works for you:
CLEAR SET ASSERTS ON create cursor period ; (QUARTER c(10), ; YEAR c(10) ; ) create cursor PERIOD1 ; (MONTH c(10), ; YEAR c(10) ; ) insert into PERIOD values('1', '10') insert into PERIOD values('2', '20') insert into PERIOD1 values('11', '11') insert into PERIOD1 values('12', '21') local xml, i, s xml = createobject('xmladapter') =xml.AddTableSchema('period') =xml.AddTableSchema('PERIOD1',.T.,STRCONV([PERIOD],12)) xml.xmlSchemalocation='' ? xml.ToXml('s',[],.t.)You have both but if you don't use case sensitive parsing after that :-)