Re: IF ELSE

[Michael Smith]

Barry:

OK, I have changed the code somewhat as below:

DELIMITER //
drop procedure IF EXISTS CountIN ;
create procedure CountIN (@cnt 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 //

DELIMITER ;

I am now getting 2 error messages:
1) The code won't stop
2) The commands are out of sync.

Any ideas?