| Subject | Re: [firebird-support] CTE Spaces between every day |
|---|---|
| Author | Svein Erling Tysvær |
| Post date | 2019-08-12T13:03:59Z |
select distinct cast(m.t || '.' || m.m || '.' || m.j as timestamp), null, null, null, null
from tkal_main m
where m.serie in ( 3, 6 ) and w.wek_id = :wek_team
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