WebSVN – eFlore/Projets.eflore-projets – Path Comparison – / – /trunk/scripts/modules/cel/maj-referentiel-und-201307.sql Rev 779 and /trunk/scripts/modules/cel/maj-referentiel-und-201307.sql Rev 780

Ignore whitespace Rev 779 → Rev 780

 /trunk/scripts/modules/cel/maj-referentiel-und-201307.sql
 ,7 → 52,7
 DECLARE _nom varchar(255) DEFAULT NULL;
 -- la requête principale de sélection des observations à mettre à jour
-DECLARE cur1 CURSOR FOR SELECT id_observation, nom_sel FROM cel_obs WHERE (nom_referentiel IS NULL OR nom_referentiel = '') AND nom_sel != '' AND nom_sel IS NOT NULL AND nom_ret_nn IS NULL; -- 78149
+DECLARE cur1 CURSOR FOR SELECT id_observation, nom_sel FROM cel_obs WHERE nom_referentiel IS NULL AND nom_sel != '' AND nom_sel IS NOT NULL AND nom_ret_nn IS NULL; -- 78149
 -- DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;
 DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = 1;