存储过程的output参数怎么拿啊????
_CommandPtr cmd;
cmd.CreateInstance("ADODB.Command");
//id号
cmd->ActiveConnection = piConnection;
cmd->CommandText="SelUser"; //存储过程的名字
_ParameterPtr pParamRk;
pParamRk.CreateInstance("ADODB.Parameter");
pParamRk=cmd->CreateParameter("xxx",adVarChar,adParamInput,12,"'fff'");
cmd->Parameters->Append(pParamRk);
//返回值
_ParameterPtr pParamOk;
pParamOk.CreateInstance("ADODB.Parameter");
pParamOk=cmd->CreateParameter("vvv",adVarChar,adParamOutput,20,"");
cmd->Parameters->Append(pParamOk);
//执行,获得结果
try
{
cmd->Execute(NULL, NULL, adCmdStoredProc);
}
catch (CException *e)
{
return "";
}
//将值返回
return (char*)_bstr_t (cmd->Parameters->GetItem("vvv")->Value);
老是在return的时候出错!谢谢!
下面是存储过程!
CREATE PROCEDURE SelUser @xxx varchar(12),
@vvv varchar(20) OUTPUT
AS
select @vvv=nickname from oftenuse where userid=@xxx
print @vvv
return @vvv
GO