[firebird-support] Re: For loop or while loop inside of a stored procedure?

[Christian Mereles]

Hi,

Loop dates within a range:

create or alter procedure SP_DATES (
    INICIO date,
    FINAL date)
returns (
    FECHA date)
as
begin
  /* Procedure Text */
  Fecha = inicio;
  while (Fecha < final) do
  begin
    Fecha = Fecha + 1;
    suspend;
  end

end


Regards.

-Christian-


[Non-text portions of this message have been removed]