--- Walter Neumann <walter@...> a
écrit : > Hi,

> I wrote a SP, which worked fine. Then I changed it,
> and now I recieve always
> ANZAHL=0. The 1. SP had no input parameters. I used
> always 'TODAY' for
> comparison. Here is the new SP:
>
> ALTER PROCEDURE "MITARB_COUNT"
> (
> "STICHTAG2" TIMESTAMP,
> "STICHTAG1" TIMESTAMP
> )
> RETURNS
> (
> "ANZAHL" INTEGER
> )
> AS
> DECLARE VARIABLE MAID INT;
> BEGIN
> ANZAHL = 0;
> FOR SELECT MA.PERSONENIDINT FROM MITARBVIEW MA
> WHERE :STICHTAG2 >= (SELECT
> MAX(EA.EINTRITTSDATUM) FROM MITARBEINAUSVIEW
> EA
> WHERE ((EA.MITARBID = MA.PERSONENIDINT)
> AND ((EA.AUSTRITTSDATUM IS NULL) OR
> (EA.AUSTRITTSDATUM >=
> :STICHTAG1))))
> INTO :MAID
> DO
> BEGIN
> ANZAHL = ANZAHL + 1;
> END
> SUSPEND;
> END
>
> Thank you for your advices.
>
> Walter
>
> ------------------------ Yahoo! Groups Sponsor
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/
>
>

Try to replace the following instructions
=============

> INTO :MAID
> DO
> BEGIN
> ANZAHL = ANZAHL + 1;
> END
> SUSPEND;

=============
by

> INTO :MAID
> DO
> BEGIN
> ANZAHL = ANZAHL + 1;
>>>> SUSPEND;
> END
>

___________________________________________________________
Do You Yahoo!? -- Une adresse @... gratuite et en français !
Yahoo! Mail : http://fr.mail.yahoo.com