为什么不行呢?各位高手,帮帮忙。
hlf 2001-12-19 03:28:10 不能将存储过程中的Char类型的变量值传回VB,代码如下:
Private Sub Command1_Click()
Dim a As New ADODB.Connection
Dim cmdtxt As New ADODB.Command
Dim s As ADODB.Parameter
Dim s2 As ADODB.Parameter
a.Open "driver={SQL Server};server=server;uid=sa;pwd=sa;database=123"
cmdtxt.ActiveConnection = a
cmdtxt.CommandText = "abc"
cmdtxt.CommandType = adCmdStoredProc
Set s = cmdtxt.CreateParameter("output", adChar, adParamOutput)'此句出错
Set s2 = cmdtxt.CreateParameter("input", adInteger, adParamInput)
cmdtxt.Parameters.Append s
cmdtxt.Parameters.Append s2
s2 = 10
cmdtxt.Execute
MsgBox cmdtxt.Parameters("output").Value
End Sub
存储过程:
CREATE PROCEDURE abc (@a char(10) output,@b int) AS
SET @a=10+@b
GO
错误提示:Parameter 对象被不正确地定义。提供了不一致或不完整的信息。