Subject TIB_StoredProc
Author guido.klapperich@t-online.de
I have a stored procedure, that looks like
CREATE PROCEDURE P_APPROVE_DISCOUNTS (
DCID INTEGER)
AS
declare variable FDID Integer;
begin
/* Übernimmt die beantragten Discount-Werte */
update DISCOUNTS set DCDISCOUNT=DCDISCOUNTNEW, DCDISCOUNTNEW=0 where
DCID=:DCID;
update DISCOUNTS_MP set DMDISCOUNT=DMDISCOUNTNEW, DMSUM=DMSUMNEW,
DMDISCOUNTNEW=0, DMSUMNEW=0 where
DMDCID=:DCID;
select FDID from FOLLOWUPDISCOUNTS where FDDCID=:DCID into :FDID;
update FOLLOWUPDISCOUNTS_MP set FMDISCOUNT=FMDISCOUNTNEW,
FMDISCOUNTNEW=0
where FMFDID=:FDID;
end

When I try to execute the SP with a TIB_StoredProc, I get the error
'multiple rows in singleton select', but I the SP do only updates. The
property StoredProcForSelect is false.


Guido.