执行存储过程时错误提示:sqlca.sqlerrtext = '对于造型说明无效的字符值'
MS SQL Server中存储过程定义为:
CREATE PROCEDURE sp_mult
@m smallint,
@n smallint,
@r smallint OUTPUT
AS
SELECT @r = @m*@n
GO
PB中执行存储过程的脚本为:
int m,n,r
m = 1
n = 2
r = 3
DECLARE Mult PROCEDURE FOR sp_mult//(:m,:n,:r output) 此形式错误提示相同
@m = :m,
@n = :n,
@r = :r OUTPUT
USING SQLCA;
EXECUTE Mult;
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)
好象是参数传递不过去。
请各位大侠指教。