Re: SQL Insert error with variables

[Ricardo Gamarra]

Thanks for the answer, but forgive me, I didn't paste the rigth code. This code is made to generate a table with numbers for a Delphi program in wich there's a combobox that displays the chapters (Capitulos), depending on wich book is selected.

This is the right code:

SET @Capitulo = 1;

CREATE TEMPORARY TABLE Temp (Capitulo INT);

WHILE @Capitulo < :Capitulos DO
INSERT INTO Temp VALUES (@Capitulo);

SET @Capitulo = @Capitulo + 1;
END WHILE;