Re: IF ELSE

[Michael Smith]

Barry:

I have significantly changed this code and it is cleared with MYSQL Workbench but it gives the error message that the procedure CountIN alreday exists

DELIMITER //

drop procedure IF EXISTS CountIN ;

DELIMITER //

create procedure CountIn (ccnt INT)


BEGIN
SELECT COUNT(ITEM) INTO @cnt FROM Invoices01 WHERE invnbr > 0;

IF @cnt = 0 THEN SELECT @mnewnumber := Nextra5 from Storage01 ;
update Invoices01 set invnbr = @mnewnumber;
END IF;

END //

drop procedure IF EXISTS CountIN (ccnt INT)

DELIMITER ;

Any suggestions?

Mike