Subject | AW: [firebird-support] CTE Spaces between every day |
---|---|
Author | Check_Mail |
Post date | 2019-08-12T12:23:31Z |
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