Set?cmd?=?New?ADODB.Command
With?cmd
????Set?.ActiveConnection?=?cnn
????.CommandText?=?"sp_abc"
????.CommandType?=?adCmdStoredProc
????.Prepared?=?True
????.Parameters.Append?.CreateParameter("retVal",?adInteger,?adParamReturnValue)?-创建返回值参数
????...
????.Execute
????Debug.Print?.Parameters("retVal").Value
End?If
的確能返回值,但是前面定義的有output的這時就不能按正常返回了.如下
.....
A?char(1)?output
B?char(1)?output
....
if?表達式?>0???
??begin
???return?2???'註意
??end
.Parameters.Append?.CreateParameter("retVal",?adInteger,?adParamReturnValue)
.Parameters.Append?.CreateParameter("A",?adChar,adParamOutput)
.Parameters.Append?.CreateParameter("B",?adChar,adParamOutput)
返而得不到A和B了.