如何在VBScript中定义游标类型输出参数 [英] How to define cursort type outparameter in VBScript

查看:73
本文介绍了如何在VBScript中定义游标类型输出参数的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我想使用具有2个i/p和3个o/p参数的VBScript(在QTP中)执行一个存储过程.一个i/p参数是String otehr是整数类型.
在O/p参数中一个是游标类型,而另外两个是字符串类型. )
设置objParameter1 = oADO_CMD.CreateParameter(变量名",adInteger,adParamInput,0)
'设置objParameter3 = oADO_CMD.CreateParameter(变量名",adVarChar,adParamOutput)
'Set objParameter2 = oADO_CMD.CreateParameter(变量名",adVariant,adParamOutput)->游标类型outparameter
'Set objParameter4 = oADO_CMD.CreateParameter(变量名",adVarChar, adParamOutput)
,当我执行此过程时,会抛出错误消息,提示传递了错误的参数".
我不确定在cr时应为游标定义哪种数据类型饮食参数.
是问题还是我犯了其他错误?

I want to execute one stored procedure using VBScript (in QTP) having 2 i/p and 3 o/p parameters.one i/p parameter is String otehr is integer type.
out of O/p parameters one is cursor type while other two are string type.
I have used createparameter like:
'Set objParameter=oADO_CMD.CreateParameter ("name of variable",adVarChar,adParamInput,5,"LONG")
Set objParameter1 = oADO_CMD.CreateParameter ("name of variable",adInteger,adParamInput ,0)
'Set objParameter3=oADO_CMD.CreateParameter("name of variable",adVarChar,adParamOutput)
'Set objParameter2 =oADO_CMD.CreateParameter("name of variable",adVariant,adParamOutput)--->Cursor type outparameter
'Set objParameter4=oADO_CMD.CreateParameter("name of variable",adVarChar,adParamOutput)
when i execute this procedure it throws me error saying "wrong arguments are passed"
I am not sure what data type shoudl be defined for cursor while creating parameter.
Is it the issue or i am making any other mistake?

推荐答案



这根本不是VBS论坛,所以这个问题的位置不对.

我不知道VBS论坛,但是通过Google搜索,我直接找到了这个论坛.

http://www.visualbasicscript.com/

Hi,

This is simply no VBS forum, so the wrong place for this question.

I don't know a VBS forum, but a search with Google gave me direct this one.

http://www.visualbasicscript.com/


这篇关于如何在VBScript中定义游标类型输出参数的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆