子
子龙
Unregistered / Unconfirmed
GUEST, unregistred user!
此interbase 存储过程哪里不对？应该怎么写？
create procedure hzb(yufen smallint,bh smallint)
returns(zzkm varchar(15),jfje double,dfje double) as begin
for select zzkm,sum(jfje),sum(dfje) from ztpzk
group by zzkm where (yufen=:yufen) and (bh=:bh)
into :zzkm,:jfje,:dfje;
do suspen;
end
create procedure hzb(yufen smallint,bh smallint)
returns(zzkm varchar(15),jfje double,dfje double) as begin
for select zzkm,sum(jfje),sum(dfje) from ztpzk
group by zzkm where (yufen=:yufen) and (bh=:bh)
into :zzkm,:jfje,:dfje;
do suspen;
end