INSERT INTO caddie_procs set type='ACTION', name='N 2.6. Remplacer un descripteur par un autre', requete='UPDATE notices_categories SET num_noeud = !!nouvelle_categorie!! WHERE notcateg_notice  in (CADDIE(NOTI)) AND num_noeud = !!ancienne_categorie!!', comment='', autorisations='1', parameters='<?xml version=\"1.0\" encoding=\"iso-8859-1\"?>
<FIELDS>
 <FIELD NAME=\"nouvelle_categorie\" MANDATORY=\"yes\">
  <ALIAS><![CDATA[Nouveau descripteur]]></ALIAS>
  <TYPE>query_list</TYPE>
<OPTIONS FOR=\"query_list\">
 <QUERY>SELECT id_noeud, libelle_categorie FROM categories, noeuds WHERE id_noeud = num_noeud and libelle_categorie not like \'~%\' AND num_renvoi_voir=0 ORDER BY libelle_categorie</QUERY>
 <MULTIPLE>no</MULTIPLE>
 <UNSELECT_ITEM VALUE=\"\"></UNSELECT_ITEM>
</OPTIONS>
 </FIELD>
 <FIELD NAME=\"ancienne_categorie\" MANDATORY=\"yes\">
  <ALIAS><![CDATA[Ancien descripteur]]></ALIAS>
  <TYPE>query_list</TYPE>
<OPTIONS FOR=\"query_list\">
 <QUERY>SELECT id_noeud, libelle_categorie FROM categories, noeuds WHERE id_noeud = num_noeud and libelle_categorie not like \'~%\' AND num_renvoi_voir=0 ORDER BY libelle_categorie</QUERY>
 <MULTIPLE>no</MULTIPLE>
 <UNSELECT_ITEM VALUE=\"\"></UNSELECT_ITEM>
</OPTIONS>
 </FIELD>
</FIELDS>'