Procedura-GetSummandsByDate

Popis:
Procedura vybere sčítance k jedné počítané položce platné v časovém omezení daném parametry

Parametry:

NázevPopisDatový typ
ACalcChart_IDChar(10)
AValidFromDateFloat(0, 0)
AValidToDateFloat(0, 0)

Návratové hodnoty:

NázevPopisDatový typ
CalcFieldCodeInteger
IDChar(10)
ValidFrom_DateFloat(0, 0)
ValidTo_DateFloat(0, 0)

Tělo:

begin
  FOR SELECT A.CalcFieldCode, A.ID, A.ValidFrom$DATE,
    (SELECT MIN(C.ValidFrom$DATE - 1) FROM CalcFields C
     WHERE C.CalcFieldCode = A.CalcFieldCode AND
       C.CalcChart_ID = A.CalcChart_ID AND
       C.FieldCode = A.FieldCode AND
       C.CLSID = A.CLSID AND
       C.ValidFrom$DATE > A.ValidFrom$DATE
    ) AS ValidTo$Date
    FROM CALCFIELDS A
    WHERE A.CalcChart_ID = :ACalcChart_ID AND
      A.ValidFrom$DATE <= :AValidToDate
    ORDER BY A.ValidFrom$DATE
    INTO :CalcFieldCode, :ID, :ValidFrom_Date, :ValidTo_Date
  DO BEGIN
    IF ((:ValidTo_Date is NULL) OR (:ValidTo_Date > :AValidFromDate)) THEN
      SUSPEND;
  END
end;

Generated by ABRA Software a.s. 27.10.2021 16:34:37