requete1_amprunt

a small application in Mysql and Delphi

CREATE  PROCEDURE requte1_emprunt( code1 VARCHAR(4), code2 VARCHAR(4), code3 VARCHAR(4),code DATE)
BEGIN 

IF code1='*'THEN
    IF code2='*' THEN
               IF code3='*' THEN
			                  IF code4='*'THEN 
							     SELECT * FROM  emprunt ;
							  ELSE SELECT * FROM  emprunt WHERE date_emprunt=code4 ;
			                  END IF;             
				 ELSEIF code4='*'THEN
						SELECT * FROM  emprunt WHERE code_exemplaire=code3;
					     ELSE SELECT * FROM  emprunt WHERE code_exemplaire=code3 AND date_emprunt=code4 ;
				 END IF;
			  END IF;
               
	ELSEif code3='*' THEN
			         IF code4='*'THEN
				     SELECT * FROM  emprunt WHERE code_film=code2;
					 ELSE SELECT * FROM  emprunt WHERE code_film=code2 AND date_emprunt=code4 ;
			         END IF;    
	    ELSEIF code4='*' THEN
					    SELECT * FROM  emprunt WHERE date_emprunt=code2 AND code_exemplaire=code3;
					    ELSE SELECT * FROM  emprunt WHERE date_emprunt=code2 AND code_exemplaire=code3 AND date_emprunt=code4 ;
			END IF;				
	 END IF;		     
			        
	END IF;				
ELSEIF code2='*' THEN
               IF code3='*'THEN
			                  IF code4='*'THEN
							  SELECT * FROM  emprunt WHERE code_personne=code1;
						 	  ELSE SELECT * FROM  emprunt WHERE code_personne=code1 AND date_emprunt=code4 ;
			                  END IF;   
			   ELSEIF code4='*' THEN
			           SELECT * FROM  emprunt WHERE code_personne=code1 AND code_exemplaire=code3;
					   ELSE SELECT * FROM  emprunt WHERE code_personne=code1 AND code_exemplaire=code3 AND date_emprunt=code4 ;														
					   END IF;
			  END IF;	   
    ELSEIF code3='*' THEN
			IF code4='*' THEN
		    	SELECT * FROM  emprunt WHERE code_personne=code1 AND code_film=code2;
		
	    	 ELSE SELECT * FROM  code_personne=code1 AND emprunt WHRE code_film=code2 AND date_emprunt=code4 ;
			END IF;		                 	                
		ELSEIF code4='*' THEN
              SELECT * FROM  emprunt WHERE code_personne=code1 AND date_emprunt=code2 AND code_exemplaire=code3;
							                 
				ELSE SELECT * FROM  emprunt WHERE code_personne=code1 AND date_emprunt=code2 AND code_exemplaire=code3 AND date_emprunt=code4 ;
	END IF;						
			END IF;
END IF;			
			        
END IF;
END/					






      IF code1='*' THEN
   IF code2='*' THEN
        IF code3='*'THEN
		   IF code4='*'THEN
		   SELECT * FROM  emprunt ;
		   ELSE SELECT * FROM  emprunt WHERE date_emprunt=code4 ;
		   END IF;
		ELSEIF code4='*'THEN
		SELECT * FROM  emprunt WHERE code_exemplaire=code3;
		ELSE SELECT * FROM  emprunt WHERE code_exemplaire=code3 AND date_emprunt=code4 ;
		END IF;
		END IF;
   ELSEIF code3='*' THEN
                 IF code4='*'THEN
				  SELECT * FROM  emprunt WHERE code_film=code2;
				 ELSE SELECT * FROM  emprunt WHERE code_film=code2 AND date_emprunt=code4 ;
				 END IF;
   ELSEIF code4='*'THEN
   SELECT * FROM  emprunt WHERE code_film=code2;
   END  SELECT * FROM  emprunt WHERE code_film=code2 AND date_emprunt=code4 ;
   END IF;
   END IF;
   END IF;
ELSEIF
END IF;