| Subject | AW: [firebird-support] CTE Spaces between every day |
|---|---|
| Author | Check_Mail |
| Post date | 2019-08-12T14:03:10Z |
Hello Set,
okay, I will test and check it, if I can take it for my situation.
Serie can be daily, weekly, monthly, half of a year or a quarter of a year, all this with reminder (days before). So it can be the situation, that I have 5 records for one day (daily and montly entries for example) and one of weekly and if there is the next day with terms, I would like to show a blank line.
Actually I have realize this with
Do
Begin
If(date <> save date)
Begin
Save output values
Set output values to null
Return
Restore output values
Set the counter + 1
end
Save the actually date
Thanks, it should work and it is okay.
Best regards
Olaf
Von: firebird-support@yahoogroups.com <firebird-support@yahoogroups.com>
Gesendet: Montag, 12. August 2019 15:04
An: firebird-support@yahoogroups.com
Betreff: Re: [firebird-support] CTE Spaces between every day
Maybe you could add something like:
union all
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
It won't quite be a blank line, but a line only containing the date.
HTH,
Set
man. 12. aug. 2019 kl. 14:23 skrev 'Check_Mail' check_mail@... [firebird-support] <firebird-support@yahoogroups.com>:
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