Data Base Error

Hi Sridhar,

We have one more problem.

Using the following XML, we are trying to update two tables which have parent-child relationship in Microsoft SQL 2000.

But it is updating only the parent table and nothing goes into child table. Can you please advise what is wrong with this structure?

<root>

<StatementName1>

<dbCUSTOMER_MASTER action="'UPDATE' | 'UPDATE_INSERT'">

<table>CUSTOMER_MASTER</table>

<access>

<CUSTOMER_NUMBER>0000002155</CUSTOMER_NUMBER>

<COUNTRY_KEY>93</COUNTRY_KEY>

<FIRST_NAME>RAVI</FIRST_NAME>

<LAST_NAME>RAVI</LAST_NAME>

<AUTHORIZATION_GROUP>new</AUTHORIZATION_GROUP>

<INDUSTRY_KEY>345</INDUSTRY_KEY>

<ACCOUNT_GROUP>123</ACCOUNT_GROUP>

<INITIAL_CONTACT>456</INITIAL_CONTACT>

<COMPANY_CODE>67</COMPANY_CODE>

</access>

<key1>

<CUSTOMER_NUMBER>0000002155</CUSTOMER_NUMBER>

</key1>

<dbCUSTOMER_ADDRESS action="'UPDATE' | 'UPDATE_INSERT'">

<table>CUSTOMER_ADDRESS</table>

<access>

<CUSTOMER_NUMBER>1</CUSTOMER_NUMBER>

<CITY>78</CITY>

<CITY_CODE>35</CITY_CODE>

<COUNTRY_CODE>91</COUNTRY_CODE>

<DISTRICT>VIZAG</DISTRICT>

<FAX_NUMBER>4567</FAX_NUMBER>

<HOUSE_NUMBER>5678</HOUSE_NUMBER>

<POSTAL_CODE>4566</POSTAL_CODE>

<REGION>CA</REGION>

<TELEPHONE_NUMBER>9866020913</TELEPHONE_NUMBER>

</access>

<key1>

<CUSTOMER_NUMBER>0000002155</CUSTOMER_NUMBER>

</key1>

</dbCUSTOMER_ADDRESS>

</dbCUSTOMER_MASTER>

</StatementName1>

</root>

Thanks,

Bhaskar and Sekhar