关于vb用ado对象连接SQL,执行带参数的存储过程
sslas 2012-12-02 10:35:45 第一种:
Set parm_opt = New ADODB.Parameter
parm_opt.Name = "optcode"
parm_opt.Type = adInteger '参数类型
parm_opt.Size = 4 '参数长度
parm_opt.Direction = adParamInput '参数方向,输入或输出
parm_opt.Value = 1000 '参数的值
cmd.Parameters.Append parm_opt '加入参数
Set parm_std = New ADODB.Parameter
parm_std.Name = "startday"
parm_std.Type = adVarChar
parm_std.Size = 10
parm_std.Direction = adParamInput
parm_std.Value = Format(DTPicker1.Value, "YYYY-MM-DD")
cmd.Parameters.Append parm_std
第二种:
set parm_opt = cmd.creatrparameter( "optcode",adInteger,adParamInput,4,1000
)
cmd.Parameters.Append parm_opt
set parm_std = cmd.creatrparameter( "startday",adVarChar,adParamInput,10,Format(DTPicker1.Value, "YYYY-MM-DD")
)
cmd.Parameters.Append parm_std
########################
为什么用第二种带参数的方式提示出错呢?