发信人: alex_d(含笑半步癫)
整理人: gzwsh(2001-05-12 23:13:29), 站内信件
|
【 在 gaodk 的大作中提到：】
:请教各位高手：ADODC怎样执行带参数的存储过程？？
:
:......
用command对象的createparameter方法创建相对输入输出参数，然后执行。如：
Set COMaccount = New ADODB.Command
With COMaccount
.CommandText = "sp_transfer_datas"
.CommandType = adCmdStoredProc
.ActiveConnection = CNrefectory
End With
Set prmEateryno = COMaccount.CreateParameter("@eatery_no", adChar, adParamInput, 1, strEateryno)
COMaccount.Parameters.Append prmEateryno
Set prmRefectoryno = COMaccount.CreateParameter("@refectory_no", adChar, adParamInput, 1, strRefectoryno)
COMaccount.Parameters.Append prmRefectoryno
Set prmDateCheck = COMaccount.CreateParameter("@date_check", adDBDate, adParamInput, , dtmDateCheck)
COMaccount.Parameters.Append prmDateCheck
COMaccount.Execute |
|