Add SUSPEND at the end of your stored procedure and you should
get the expected result.

Regards,
Thomas Steinmaurer
IB LogManager 2.0 - The Logging/Auditing Tool for InterBase and Firebird
http://www.iblogmanager.com

> -----Original Message-----
> From: R. Tulloch [mailto:tultalk@...]
> Sent: Monday, June 10, 2002 1:25 PM
> To: ib-support@yahoogroups.com
> Subject: Re: [ib-support] Another Question on SP
>
>
> Hi:
>
> SELECT TOTCOUNT FROM GENERATECASSCERTIFICATIONDATA returns null.
>
> EXECUTE PROCEDURE GENERATECASSCERTIFICATIONDATA returns correct
> result.
>
> Why wouldn't the SELECT return the result?
>
>
>
> > Should be:
> >
> > SET TERM ## ;
> > CREATE PROCEDURE GENERATECASSCERTIFICATIONDATA
> > RETURNS (TotCount INT) <--------------------------
> > AS
> > BEGIN
> > DELETE FROM CASSADD;
> > INSERT INTO CASSADD (ID, STATUS_MEM, POBOX, NUMBER,
> > STREET, CITY, STATE, ZIP, DPBC_2, DPBC_CHK)
> > SELECT M.ID, M.STATUS_MEM, M.POBOX, M.NUMBER, M.STREET,
> > M.CITY, M.STATE, M.ZIP, M.DPBC_2, M.DPBC_CHK
> > FROM MEMBERS M
> > WHERE M.STATUS_REC <> 'ARCHIVE' AND ((M.POBOX IS NOT NULL AND
> > M.POBOX <> 0) OR
> > (M.NUMBER IS NOT NULL AND
> > M.NUMBER <> 0));
> > INSERT INTO CASSADD (ID, STATUS_MEM, POBOX, NUMBER,
> > STREET, CITY, STATE, ZIP, DPBC_2, DPBC_CHK)
> > SELECT I.ID, I.STATUS_MEM, I.POBOX, I.NUMBER, I.STREET,
> > I.CITY, I.STATE, I.ZIP, I.DPBC_2, I.DPBC_CHK
> > FROM INFOLIST I
> > WHERE I.STATUS_REC <> 'ARCHIVE' AND ((I.POBOX IS NOT NULL AND
> > I.POBOX <> 0) OR
> > (I.NUMBER IS NOT NULL AND
> > I.NUMBER <> 0));
> > INSERT INTO CASSADD (ID, STATUS_MEM, POBOX, NUMBER,
> > STREET, CITY, STATE, ZIP, DPBC_2, DPBC_CHK)
> > SELECT A.ID, A.STATUS_MEM, A.POBOX, A.NUMBER, A.STREET,
> > A.CITY, A.STATE, A.ZIP, A.DPBC_2, A.DPBC_CHK
> > FROM ADVERS A
> > WHERE A.STATUS_REC <> 'CANCELLED' AND ((A.POBOX IS NOT NULL AND
> > A.POBOX <> 0) OR
> > (A.NUMBER IS NOT NULL AND
> > A.NUMBER <> 0));
> > INSERT INTO CASSADD (ID, STATUS_MEM, POBOX, NUMBER,
> > STREET, CITY, STATE, ZIP, DPBC_2, DPBC_CHK)
> > SELECT AC.ID, AC.STATUS_MEM, AC.POBOX, AC.NUMBER, AC.STREET,
> > AC.CITY, AC.STATE, AC.ZIP, AC.DPBC_2, AC.DPBC_CHK
> > FROM ASSOC_C AC
> > WHERE AC.STATUS_MEM <> 'CANCELLED' AND ((AC.POBOX IS NOT NULL AND
> > AC.POBOX <> 0) OR
> > (AC.NUMBER IS NOT NULL AND
> > AC.NUMBER <> 0));
> > UPDATE CASSADD
> > SET ADDRESS = 'P O BOX ' || CAST(CAST(POBOX AS INTEGER) AS CHAR(7))
> > WHERE (POBOX IS NOT NULL AND POBOX <> 0);
> > UPDATE CASSADD
> > SET ADDRESS = RTRIM(CAST(CAST(NUMBER AS INTEGER) AS CHAR(7))) || ' '
> > || STREET
> > WHERE (NUMBER IS NOT NULL AND NUMBER <> 0);
> > SELECT COUNT (*) FROM CASSADD <-----------------
> > INTO TotCount;
> > END ##
> > SET TERM ; ##
> >
> >
> > 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/


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/