Subject AW: [firebird-support] CTE Spaces between every day
Author Check_Mail

Hello Karol,

 

I had the same idea, but it is a little bit complex. First, I must save the last date, if the new one ist different, I must save all return variables, set it to null, suspend the record and restore the saved return values and suspend this. So I have the old Date, the blank record and the new one. I thought, there is a simplier way.

 

Thank you.

 

Von: firebird-support@yahoogroups.com <firebird-support@yahoogroups.com>
Gesendet: Montag, 12. August 2019 12:17
An: firebird-support@yahoogroups.com; 'Check_Mail' check_mail@... [firebird-support] <firebird-support@yahoogroups.com>
Betreff: Re: [firebird-support] CTE Spaces between every day

 

 

Hi,

 

simply add loop inside

do

  begin

     suspend;

    --put here some loop

    while something do

      begin

          --modify output variables here

          suspend;

      end

  end;

 

regards,

Karol Bieniaszewski