Public Function callPr_restore(ByVal conn As Connection, pr_restore_name As String)
Dim CNN_cmd As ADODB.Command
Set CNN_cmd = New ADODB.Command
Set CNN_cmd.ActiveConnection = conn
CNN_cmd.CommandText = pr_restore_name
CNN_cmd.CommandType = adCmdStoredProc
'------------------------有参存储过程加以下代码----------------------------------
With CNN_cmd
' 两种方式给参数赋值
' 第一种:CNN_cmd.P阿rameters(参数索引).value = 参数值
' 第二种:.CNN_cmd.Parameters.Append .CreateParameter(参数名,adVarChar, adParamInput, 10,
参数值)
.Parameters(1).Value = "20030611"
.Parameters.Append .CreateParameter("stunum", adVarChar, adParamInput, 10, "20030610")
.Parameters.Append .CreateParameter("sPrefix", adVarChar, adParamInput, 4, "2004")
.Parameters.Append .CreateParameter("iLength", adInteger, adParamInput, , 5)
.Parameters.Append .CreateParameter("sSequenceNumber", adVarChar, adParamOutput, 7,
sSequenceNumber)
End With
'---------------------------------------END--------------------------------------------
本内容试读结束,登录后可阅读更多
下载后可阅读完整内容,剩余2页未读,立即下载