|Subject||AW: [firebird-support] CTE Spaces between every day|
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
If(date <> save date)
Save output values
Set output values to null
Restore output values
Set the counter + 1
Save the actually date
Thanks, it should work and it is okay.
Maybe you could add something like:
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.
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.
simply add loop inside
--put here some loop
while something do
--modify output variables here