Re: SQL Insert error with variables
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;
Subject
Written By
Posted
Re: SQL Insert error with variables
August 18, 2014 05:25PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.