FOR SELECT TERMINAL, SUM(TOTAL) FROM DOCKETS GROUP BY TERMINAL INTO
:TERMINALID, :STOTAL DO BEGIN
SUSPEND;
END

-----Original Message-----
From: Zakir Mahomedy [mailto:zmahomedy@...]
Sent: Friday, 21 March 2003 6:46 PM
To: ib-support@yahoogroups.com
Subject: [ib-support] Store Procedure Problem



I created a store procedure which needs to return totals from different
terminals. It works fine when theres only 1 terminal. If there is more then
1 terminal I get an error

"Multiple rows in Single Select" . How do i fix my code to allow for
multiple rows.

Thank you in advance for any solution.

Here is my store procedure.

....

AS

BEGIN

SELECT TERMINAL, SUM(TOTAL) FROM DOCKETS

GROUP BY TERMINAL

INTO :TERMINALID, :STOTAL;

SUSPEND;

END

...


|


---------------------------------
Do you Yahoo!?
Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!

[Non-text portions of this message have been removed]



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/