Re: Stored Procedure

[Michael Smith]

I have simplified the code as below:

I am still getting an error message from my debugger about the first 3 lines.

Any guidance would be appreciated.

Mike
*********


update Invoices02 set EXTRA1 = " ";

DELIMITER //


CREATE PROCEDURE pbackup1(IN mContinue)

BEGIN

let mContinue = "YES";

while (mContinue = "YES") {

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

IF @CCNT1 > O 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; //

DELIMITER ;