Re: Stored Procedure

[Michael Smith]

Hi Barry:

I have updated my code as below but I am still getting an error message about the first 3 lines.

Mike
*******
CREATE PROCEDURE pbackup1()

BEGIN

DECLARE nContinue varchar(20) DEFAULT " ";

let mContinue = "YES";

WHILE mContinue = "YES" DO

SELECT @CCNT1 := COUNT(Check01) FROM Invoices02 where Check01 = 1 and EXTRA1 = " ";

IF @CCNT1 > 0 THEN
@mInvnbr := SELECT Invnbr FROM Invoices02 WHERE Check01 = 1 and EXTRA1 = " ";
update Invoices02 set EXTRA1 = "X" where Invnbr = @mInvnbr;
ELSE
mContinue = 'NO';
END IF;
END WHILE;

END //

DELIMITER ;