><?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> >>
>XMLTOCURSOR('MR.xml','Temp',512) >set >SELECT temp >browse >>