举例:
private sub
dim inSN as string '假定你用的序列号为字符串
dim outRet as long '假定你用的返值为整型
dim cnn as new connection
dim cmd as new command
dim param1 as new parameter
dim param2 as new parameteron error goto Err
//建立数据库连接
cnn.connectionstring=你要的连接串
cnn.open
set cmd.activeconnection=cnn
//设置命令对象
cmd.commandtype=adcmdstoredprocedure
cmd.commandtext=你写的存储过程名
//添加参数对象
set param1=cmd.createparameter("insn",advarchar,adparaminput,50,inSN)
set param2=cmd.createparameter("RetVal",adinteger,adparamoutput)
cmd.parameters.append param1
cmd.parameters.append param2
//执行之
cmd.execute
//得到结果 OutRet=clng(param2) '得到你想要的返回值exit sub
Err:
msgbox err.number & err.descrpition
end sub
private sub
dim inSN as string '假定你用的序列号为字符串
dim outRet as long '假定你用的返值为整型
dim cnn as new connection
dim cmd as new command
dim param1 as new parameter
dim param2 as new parameteron error goto Err
//建立数据库连接
cnn.connectionstring=你要的连接串
cnn.open
set cmd.activeconnection=cnn
//设置命令对象
cmd.commandtype=adcmdstoredprocedure
cmd.commandtext=你写的存储过程名
//添加参数对象
set param1=cmd.createparameter("insn",advarchar,adparaminput,50,inSN)
set param2=cmd.createparameter("RetVal",adinteger,adparamoutput)
cmd.parameters.append param1
cmd.parameters.append param2
//执行之
cmd.execute
//得到结果 OutRet=clng(param2) '得到你想要的返回值exit sub
Err:
msgbox err.number & err.descrpition
end sub
解决方案 »
- sql2005 express安装后 sql2000菜单消失啦
- 急求一条SQL语句,在线等待
- 存储过程嵌套后,返回值的问题?
- 关于前台捕捉后台procedure, trigger返回的错误
- SQLSERVER2008用windows身份登录一切正常,用sqlserver身份登录错误
- SQL2000的怪问题,帮我者给100分
- 求助!怎么同时显示两个不同记录的列
- 如何实现每天自动从ORACLE中取表名是动态的数据
- 凭证检索的简单问题
- EF Model First 如何在模型中加入非主键或外键的 索引和约束???
- SQL安装的问题,请高手们来帮帮我这个菜鸟,小弟感激不尽!~~~~~
- 如何保持像外键一样的级联更新,但不对它进行删除
set strSQL = "
declare @a char(15)
exec update_po_head ...,@a output
select @a "
rs.open strSQL
messagebox rs.fields(0)
With cmdExecute
.ActiveConnection = CN
.CommandText = strSQL
.CommandType = adCmdText
.Parameters.Append .CreateParameter(, adChar, adParamOutput, 15)
End With
cmdExecute.Execute