FoxLearner
Programmer
Hi All
Can any one tell me how to generate a single XML document from multiple cursors? I need to call a webservice with the following examples of xml schema and xml document.
The schema is something like this:
***********************
<?xml version="1.0" standalone="yes"?>
<xs:schema id="NewDataSet" xmlns="" xmlns:xs=" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
<xs:element name="NewDataSet" msdata:IsDataSet="true">
<xs:complexType>
<xs:choice maxOccurs="unbounded">
<xs:element name="OutputOptions">
<xs:complexType>
<xs:sequence>
<xs:element name="Cover" type="xs:boolean" minOccurs="0" />
<xs:element name="UnderwriterInfo" type="xs:boolean" minOccurs="0" /> .....
.....
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="GroupInformation">
<xs:complexType>
<xs:sequence>
<xs:element name="Application" type="xs:string" minOccurs="0" />
<xs:element name="UserName" type="xs:string" minOccurs="0" />
.....
.....
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="IndividualCensus">
<xs:complexType>
<xs:sequence>
<xs:element name="TierLevel" type="xs:string" minOccurs="0" />
<xs:element name="Sex" type="xs:string" minOccurs="0" />
....
....
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="Plan1">
<xs:complexType>
<xs:sequence>
<xs:element name="RatingID" type="xs:string" minOccurs="0" />
<xs:element name="OldRenewal" type="xs:boolean" minOccurs="0" />
<xs:element name="CoinsuranceInNetwork" type="xs:string" minOccurs="0" />
........
........
........
********************
Data comes from cursors curOutputOptions, curGroupInfo, curIndCensus, curPlan1,...
The XML Document looks something like this:
*********************
<?xml version="1.0" standalone="yes"?>
<NewDataSet>
<OutputOptions>
<Cover>true</Cover>
<UnderwriterInfo>true</UnderwriterInfo>
<AgeSexRateDetail>true</AgeSexRateDetail>
<AgeSexRateEmpContr>true</AgeSexRateEmpContr>
<Rates>true</Rates>
<Algorithm>false</Algorithm>
<AlgorithmDetail>false</AlgorithmDetail>
<LOB>false</LOB>
</OutputOptions>
<GroupInformation>
<Application>MarketingApp</Application>
<UserName>MJONSON1</UserName>
<UserType>TESTER</UserType>
.... .....
</GroupInformation>
<IndividualCensus>
<TierLevel>4</TierLevel>
<Sex>M</Sex>
<ContractType>EE</ContractType>
<CobraContract>false</CobraContract>
<MemberType>Emp</MemberType>
<ContractCode></ContractCode>
<Name>James Bond</Name>
<DateofBirth>1978-11-01</DateofBirth>
<Age>25</Age>
<Zip>72201</Zip>
</IndividualCensus>
<IndividualCensus>
<TierLevel>4</TierLevel>
<Sex>M</Sex> ....
.....
</IndividualCensus>
<PPOPlan>
<RatingID>MWRate0</RatingID>
<OldRenewal>false</OldRenewal>
<PlanSequence>0</PlanSequence>
....
....
***************************
I have the schema and cursors but don't know how to generate this type of XML document.
Will you please tell me /show me reference where I can learn this ASAP?
Thanks and Regards
FoxLearner
Can any one tell me how to generate a single XML document from multiple cursors? I need to call a webservice with the following examples of xml schema and xml document.
The schema is something like this:
***********************
<?xml version="1.0" standalone="yes"?>
<xs:schema id="NewDataSet" xmlns="" xmlns:xs=" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">
<xs:element name="NewDataSet" msdata:IsDataSet="true">
<xs:complexType>
<xs:choice maxOccurs="unbounded">
<xs:element name="OutputOptions">
<xs:complexType>
<xs:sequence>
<xs:element name="Cover" type="xs:boolean" minOccurs="0" />
<xs:element name="UnderwriterInfo" type="xs:boolean" minOccurs="0" /> .....
.....
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="GroupInformation">
<xs:complexType>
<xs:sequence>
<xs:element name="Application" type="xs:string" minOccurs="0" />
<xs:element name="UserName" type="xs:string" minOccurs="0" />
.....
.....
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="IndividualCensus">
<xs:complexType>
<xs:sequence>
<xs:element name="TierLevel" type="xs:string" minOccurs="0" />
<xs:element name="Sex" type="xs:string" minOccurs="0" />
....
....
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="Plan1">
<xs:complexType>
<xs:sequence>
<xs:element name="RatingID" type="xs:string" minOccurs="0" />
<xs:element name="OldRenewal" type="xs:boolean" minOccurs="0" />
<xs:element name="CoinsuranceInNetwork" type="xs:string" minOccurs="0" />
........
........
........
********************
Data comes from cursors curOutputOptions, curGroupInfo, curIndCensus, curPlan1,...
The XML Document looks something like this:
*********************
<?xml version="1.0" standalone="yes"?>
<NewDataSet>
<OutputOptions>
<Cover>true</Cover>
<UnderwriterInfo>true</UnderwriterInfo>
<AgeSexRateDetail>true</AgeSexRateDetail>
<AgeSexRateEmpContr>true</AgeSexRateEmpContr>
<Rates>true</Rates>
<Algorithm>false</Algorithm>
<AlgorithmDetail>false</AlgorithmDetail>
<LOB>false</LOB>
</OutputOptions>
<GroupInformation>
<Application>MarketingApp</Application>
<UserName>MJONSON1</UserName>
<UserType>TESTER</UserType>
.... .....
</GroupInformation>
<IndividualCensus>
<TierLevel>4</TierLevel>
<Sex>M</Sex>
<ContractType>EE</ContractType>
<CobraContract>false</CobraContract>
<MemberType>Emp</MemberType>
<ContractCode></ContractCode>
<Name>James Bond</Name>
<DateofBirth>1978-11-01</DateofBirth>
<Age>25</Age>
<Zip>72201</Zip>
</IndividualCensus>
<IndividualCensus>
<TierLevel>4</TierLevel>
<Sex>M</Sex> ....
.....
</IndividualCensus>
<PPOPlan>
<RatingID>MWRate0</RatingID>
<OldRenewal>false</OldRenewal>
<PlanSequence>0</PlanSequence>
....
....
***************************
I have the schema and cursors but don't know how to generate this type of XML document.
Will you please tell me /show me reference where I can learn this ASAP?
Thanks and Regards
FoxLearner