//////////
PB中的代码:
string ls_muh
int li_rowcou
ls_muh = "123"
declare sp_smhrepeat procedure for cf_SmhRepeat
@muh = :ls_muh,
@rowcou = :li_rowcou output;
execute sp_smhrepeat;
if sqlca.sqlcode = 0 then
fetch sp_smhrepeat into :li_rowcou;
messagebox("成功",string(li_rowcou))
else
messagebox("错误",sqlca.sqlerrtext)
end if
close sp_smhrepeat;
//////////////////////////////
SQL SERVER 2000中的存储过程代码:
CREATE PROCEDURE cf_SmhRepeat (@muh char(12), @rowcou int output)
as
if isnull(@muh,'0') = '0'
begin
set @rowcou = -1
return
end
select @rowcou = count(ts_muh) from ts_cfmaint where ts_muh = @muh
GO
declare sp_smhrepeat procedure for cf_SmhRepeat(:ls_muh,:li_rowcou);
execute sp_smhrepeat;
if sqlca.sqlcode = 0 then
fetch sp_smhrepeat into :li_rowcou;
messagebox("成功",string(li_rowcou))
else
messagebox("错误",sqlca.sqlerrtext)
end if
close sp_smhrepeat;
调用成功,但是li_rowcou未被赋值。