dim cmd as adodb.command
dim cnn as adodb.conection
cnn.open........
with cmd
.CommandType = adCmdStoredProc
.ActiveConnection = cnn
.CommandText = "torec"
.Parameters.Append cmd.CreateParameter("c_date", adVarChar, adParamInput, 8, emrecord.emdate)
.Parameters.Append cmd.CreateParameter("c_time", adVarChar, adParamInput, 4, itime)
.Parameters.Append cmd.CreateParameter("c_amt", adVarChar, adParamInput, 2, emrecord.emamt)
end with
cmm.exec 然后這個過程是循環調用的.
報錯:too many arguments supplied for procedure tore,我就不懂,定義了這
么多參數, sqlserver怎么知道要傳給過程中的哪個參數.要怎么解決呢?
dim cnn as adodb.conection
cnn.open........
with cmd
.CommandType = adCmdStoredProc
.ActiveConnection = cnn
.CommandText = "torec"
.Parameters.Append cmd.CreateParameter("c_date", adVarChar, adParamInput, 8, emrecord.emdate)
.Parameters.Append cmd.CreateParameter("c_time", adVarChar, adParamInput, 4, itime)
.Parameters.Append cmd.CreateParameter("c_amt", adVarChar, adParamInput, 2, emrecord.emamt)
end with
cmm.exec 然后這個過程是循環調用的.
報錯:too many arguments supplied for procedure tore,我就不懂,定義了這
么多參數, sqlserver怎么知道要傳給過程中的哪個參數.要怎么解決呢?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货