i have this file MR.XLM
<?xml version="1.0" encoding="ISO-8859-1"?>
<MR>
<groups>
<group>
<group-id>1</group-id>
<group-Name>Aides soignants</group-Name>
</group>
<group>
<group-id>2</group-id>
<group-Name>Infirmiers</group-Name>
</group>
<group>
<group-id>3</group-id>
<group-Name>Service technique</group-Name>
</group>
</groups>
<AllStaff>
<Staff>
<Staff-id>31</Staff-id>
<Staff-code>458</Staff-code>
<Staff-fname>Angela</Staff-fname>
<Staff-lname>Carobbio</Staff-lname>
<group-id>1</group-id>
</Staff>
<Staff>
<Staff-id>28</Staff-id>
<Staff-code>233</Staff-code>
<Staff-fname>Anne</Staff-fname>
<Staff-lname>Carton</Staff-lname>
<group-id>2</group-id>
</Staff>
<Staff>
<Staff-id>17</Staff-id>
<Staff-code>143</Staff-code>
<Staff-fname>SABINE</Staff-fname>
<Staff-lname>CHEVALIER</Staff-lname>
<group-id>3</group-id>
</Staff>
<Staff>
<Staff-id>27</Staff-id>
<Staff-code>99</Staff-code>
<Staff-fname>Claude</Staff-fname>
<Staff-lname>Deleuze</Staff-lname>
<group-id>1</group-id>
</Staff>
</AllStaff>
<srvs>
<srv>
<srv-id>1</srv-id>
<srv-Name>1er étage</srv-Name>
</srv>
<srv>
<srv-id>2</srv-id>
<srv-Name>Rez</srv-Name>
</srv>
</srvs>
<doctors>
<doctor>
<doctor-id>1</doctor-id>
<doctor-fName>Bruno</doctor-fName>
<doctor-lName>Cambier</doctor-lName>
<doctor-phone>0123456789</doctor-phone>
</doctor>
<doctor>
<doctor-id>2</doctor-id>
<doctor-fName>Christophe</doctor-fName>
<doctor-lName>Durieux</doctor-lName>
<doctor-phone>066998855</doctor-phone>
</doctor>
</doctors>
<beds>
<bed>
<bed-id>940</bed-id>
<bed-room>12</bed-room>
<bed-num>1</bed-num>
<bed-srv>2</bed-srv>
</bed>
<bed>
<bed-id>970</bed-id>
<bed-room>105</bed-room>
<bed-num>2</bed-num>
<bed-srv>1</bed-srv>
</bed>
<bed>
<bed-id>18</bed-id>
<bed-room>118</bed-room>
<bed-num>1</bed-num>
<bed-srv>1</bed-srv>
</bed>
<bed>
<bed-id>237</bed-id>
<bed-room>18</bed-room>
<bed-num>1</bed-num>
<bed-srv>2</bed-srv>
</bed>
</beds>
<boarders>
<boarder>
<boarder-id>123</boarder-id>
<boarder-fName>Denise</boarder-fName>
<boarder-lName>Goret</boarder-lName>
<boarder-bed>940</boarder-bed>
<boarder-doctor>2</boarder-doctor>
</boarder>
<boarder>
<boarder-id>244</boarder-id>
<boarder-fName>Pierre</boarder-fName>
<boarder-lName>Dupont</boarder-lName>
<boarder-bed>970</boarder-bed>
</boarder>
<boarder>
<boarder-id>180</boarder-id>
<boarder-fName>Coraline</boarder-fName>
<boarder-lName>Lison</boarder-lName>
<boarder-bed>18</boarder-bed>
<boarder-doctor>1</boarder-doctor>
</boarder>
</boarders>
<cares>
<care>
<care-id>1</care-id>
<care-Name>Plan de soins</care-Name>
</care>
<care>
<care-id>10</care-id>
<care-Name>Habillage</care-Name>
<care-up>1</care-up>
</care>
<care>
<care-id>101</care-id>
<care-Name>Aide partielle</care-Name>
<care-value>0</care-value>
<care-groupsOK>
<group-id>1</group-id>
<group-id>2</group-id>
</care-groupsOK>
<care-up>10</care-up>
</care>
<care>
<care-id>102</care-id>
<care-Name>Aide totale</care-Name>
<care-value>0</care-value>
<care-groupsOK>
<group-id>1</group-id>
<group-id>2</group-id>
</care-groupsOK>
<care-up>10</care-up>
</care>
<care>
<care-id>11</care-id>
<care-Name>Toilette</care-Name>
<care-up>1</care-up>
</care>
<care>
<care-id>111</care-id>
<care-Name>Douche</care-Name>
<care-value>0</care-value>
<care-groupsOK>
<group-id>1</group-id>
</care-groupsOK>
<care-up>11</care-up>
</care>
<care>
<care-id>112</care-id>
<care-Name>Toilette au Lavabo</care-Name>
<care-value>0</care-value>
<care-groupsOK>
<group-id>1</group-id>
</care-groupsOK>
<care-up>11</care-up>
</care>
<care>
<care-id>113</care-id>
<care-Name>Mettre au WC</care-Name>
<care-value>0</care-value>
<care-groupsOK>
<group-id>1</group-id>
<group-id>2</group-id>
</care-groupsOK>
<care-up>11</care-up>
</care>
<care>
<care-id>12</care-id>
<care-Name>Alimentation</care-Name>
<care-up>1</care-up>
</care>
<care>
<care-id>121</care-id>
<care-Name>Conduire au restaurant</care-Name>
<care-value>0</care-value>
<care-groupsOK>
<group-id>1</group-id>
<group-id>2</group-id>
</care-groupsOK>
<care-up>12</care-up>
</care>
<care>
<care-id>128</care-id>
<care-Name>Hydrater</care-Name>
<care-value>0</care-value>
<care-groupsOK>
<group-id>1</group-id>
<group-id>2</group-id>
</care-groupsOK>
<care-up>12</care-up>
</care>
<care>
<care-id>2</care-id>
<care-Name>Biométries</care-Name>
</care>
<care>
<care-id>21</care-id>
<care-Name>Température</care-Name>
<care-value>2</care-value>
<care-min>35</care-min>
<care-max>45</care-max>
<care-unit>°C</care-unit>
<care-groupsOK>
<group-id>1</group-id>
<group-id>2</group-id>
</care-groupsOK>
<care-up>2</care-up>
</care>
<care>
<care-id>23</care-id>
<care-Name>Tension</care-Name>
<care-value>3</care-value>
<care-unit>mmHg</care-unit>
<care-groupsOK>
<group-id>2</group-id>
</care-groupsOK>
<care-up>2</care-up>
</care>
</cares>
<products>
<product>
<product-id>0</product-id>
<product-Name>Produits</product-Name>
</product>
<product>
<product-id>1</product-id>
<product-Name>Boissons</product-Name>
<product-up>0</product-up>
</product>
<product>
<product-id>11</product-id>
<product-Name>Eau 25 cl</product-Name>
<product-cost>1.00</product-cost>
<product-groupsOK>
<group-id>2</group-id>
</product-groupsOK>
<product-up>1</product-up>
</product>
<product>
<product-id>12</product-id>
<product-Name>Coca 33 cl</product-Name>
<product-cost>1.25</product-cost>
<product-groupsOK>
<group-id>2</group-id>
</product-groupsOK>
<product-up>1</product-up>
</product>
<product>
<product-id>2</product-id>
<product-Name>Fruits</product-Name>
<product-up>0</product-up>
</product>
<product>
<product-id>21</product-id>
<product-Name>Pomme</product-Name>
<product-groupsOK>
<group-id>1</group-id>
<group-id>2</group-id>
</product-groupsOK>
<product-up>2</product-up>
</product>
<product>
<product-id>22</product-id>
<product-Name>Raisin</product-Name>
<product-cost>1.50</product-cost>
<product-groupsOK>
<group-id>2</group-id>
</product-groupsOK>
<product-up>2</product-up>
</product>
</products>
</MR>when i try to import into a cursor ,
XMLTOCURSOR('MR.xml','Temp',512)
set
SELECT temp
browse i have this result :
http://www.amline.be/UT_DOC/ut1.jpgThe result is strong...
why ?
thank in advance for help
bernhart
