急!PB调用及其简单的MS SQL Server2000中带输入输出参数的存储过程。(进者有分)
MS SQL Server2000中存储过程定义如下:
REATE PROCEDURE sp_mult
@a int,
@b int,
@c int output
AS
select @c=@a*@b
GO
PB中脚本如下:
long m,n,r
m = 1
n = 2
r = 3
DECLARE Mult PROCEDURE FOR sp_mult //(:m,:n,:r output)此形式错误提示相同
@a = :m,
@b = :n,
@c = :r OUTPUT
USING SQLCA;
EXECUTE Mult ;
FETCH Mult INTO :r;
if sqlca.sqlcode=0 then
messagebox("提示","执行成功")
else
messagebox("提示","发生错误,原因在" + sqlca.sqlerrtext )
end if
FETCH Mult INTO :r;
CLOSE Mult ;
sle_1.text = string(r) //结果r为3,正确应该为2
Messagebox提示如下:
发生错误,原因在 Cursor is not open
先谢过各位大侠了!!