LOOP - variable not found

[former_SQLA_member1694879]

Trying to run a loop statement, but it fails at the first line with - Variable 'i' not found. Do I need to define this first somehow? Thanks

SET i = 203;
WHILE i <= 264 LOOP
SELECT Cust_Name AS RC_Name FROM Customers WHERE Customer_ID = i ;

--- INSERT STATEMENTS ---

SET i = i + 1;
END LOOP;

[Former Member · Accepted solution]

Hi, you need to declare or create it first:

CREATE VARIABLE i INTEGER;

Alternatively, you will need to declare it, but then you will need to use compound statement:

BEGIN

DECLARE i INTEGER;

--YOUR CODE--

END;

[former_SQLA_member1694879 · Accepted solution]

Compound statement?

[johnsmirnios · Accepted solution]

You probably don't want that first one -- that creates a connection-scope variable that persists until your connection is dropped or you explicitly drop the variable.

[former_SQLA_member1694879 · Accepted solution]

Using CREATE VARIABLE throws - Syntax error near 'SET'

[former_SQLA_member1694879 · Accepted solution]

Using BEGIN and END; (Compound Statement??) works - thank you

[Breck_Carter · Accepted solution]

That is actually the definition of a "compound statement"... a BEGIN ... END.

[former_SQLA_member1694879 · Accepted solution]

We have an isolated existence here 🙂 Will try to remember that.

[Vlad · Accepted solution]

Oh! Now I know the new term! Thank you Breck!