Set rst = cmd.Execute("exec JD_Qnddjg_BB1 @Bln_jtlx=0,@strRb='',@Bdate='2006-01-01',@Edate='2006-05-01' ")
请指点
...全文
923打赏收藏
高人指点谢谢
我用以下语句调用存储过程出错 Set rst = New ADODB.Recordset Set rst = cmd.Execute("exec JD_Qnddjg_BB1 @Bln_jtlx=0,@strRb='',@Bdate='2006-01-01',@Edate='2006-05-01' ") 请指点
Dim parm_rb As ADODB.Parameter
Dim parm_Sdate As ADODB.Parameter
Dim parm_Edate As ADODB.Parameter
Dim mcn As New ADODB.Connection
If CnnDbf(mcn) = False Then
Exit Sub
End If
'strsql = "JD_Qnddjg_BB1 '" & Me.chkJTLX.value & "','" & MstrRb & "','" & Format(Me.dtpStart.value, "YYYY-mm-dd") & "','" & Format(Me.dtpEnd.value, "YYYY-mm-dd") & "'"
cmd.ActiveConnection = mcn
cmd.CommandText = "JD_Qnddjg_BB1"
cmd.CommandType = adCmdStoredProc
Set parm_jtlx = New ADODB.Parameter
parm_jtlx.Type = adInteger
parm_jtlx.Size = 3
parm_jtlx.Direction = adParamInput
parm_jtlx.value = 0
cmd.Parameters.Append parm_jtlx