Stored Procedure

[Michael Smith]

I can't get the stored procedure to start. The debugger is saying that there is something wrong in the first 3 lines.

Can someone help me with this?

Thanks

Mike
************


DELIMITER //

CREATE PROCEDURE pbackup1(IN mContinue)

BEGIN

let mContinue = "YES";

while (mContinue = "YES") {

SELECT @CCNT1 := COUNT(Check01) FROM Invoices02 where Userno = {{ localStorage.values.Userno }} and Check01 = 1 and EXTRA1 = " ";

IF @CCNT1 > O THEN
@mInvnbr := SELECT Invnbr FROM Invoices02 WHERE Userno = {{ localStorage.values.Userno }} AND Check01 = 1 and EXTRA1 = " ";
update Invoices02 set EXTRA1 = "X" where Invnbr = @mInvnbr;
ELSE
mContinue = 'NO';
END IF;
}

END; //

DELIMITER ;