如何在VBScript中定义游标类型输出参数 [英] How to define cursort type outparameter in 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屋!