1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29
| CREATE PROCEDURE `AjoutClient`(
IN sPrenom varchar(50),
IN sNom varchar(50),
IN sAdresse varchar(250),
IN sCP varchar(5),
IN sVille varchar(50),
IN sPays varchar(20),
IN sTel1 varchar(14),
IN sTel2 varchar(20),
IN sCourriel varchar(50),
IN sCommentaires varchar(250),
IN nCodeTourOp tinyint(4),
OUT sERR varchar(1000)
)
BEGIN
DECLARE sERR varchar(1000);
DECLARE sChampsOb varchar(1000);
DECLARE bChampsOb tinyint(1) DEFAULT 0;
SET sERR := null;
SET sChampsOb :='Champs obligatoires :<br/>';
/*Champs obligatoires*/
IF sPrenom is null then
SET sChampsOb := sChampsOb || 'Pr?nom<br/>';
SET bChampsOb := 1;
END IF;
IF bChampsOb=1 THEN
SELECT sChampsOb INTO sERR;
END IF;
END |