在vb前端取一个记录集后,循环recordset的每个记录调用下面的存储过程,
With cmd
.ActiveConnection = Conn
.CommandType = adCmdStoredProc
.CommandText = "sp_protected_au" Set pa = .CreateParameter("@implemente_date", adDBTimeStamp, adParamInput)
.Parameters.Append pa
pa.value = RsFlights!implemente_date Set pa = .CreateParameter("@flight_date", adDBTimeStamp, adParamInput)
.Parameters.Append pa
pa.value = RsFlights!flight_date Set pa = .CreateParameter("@carr", adChar, adParamInput, 4)
.Parameters.Append pa
pa.value = RsFlights!carr Set pa = .CreateParameter("@flight_no", adChar, adParamInput, 5)
.Parameters.Append pa
pa.value = RsFlights!flight_no Set pa = .CreateParameter("@enter_time", adDBTimeStamp, adParamInput)
.Parameters.Append pa
pa.value = RsFlights!enter_time Set pa = .CreateParameter("@agent", adChar, adParamInput, 8)
.Parameters.Append pa
pa.value = RsFlights!agent Set pa = .CreateParameter("@success", adInteger, adParamOutput)
.Parameters.Append pa .Execute
IntReturn = cmd("@success")
End With
第一次成功,但是到第二次就提示:
"Too many arguments were supplied for procedure sp_protected_au"
请那位能诊断一下不胜感谢!
With cmd
.ActiveConnection = Conn
.CommandType = adCmdStoredProc
.CommandText = "sp_protected_au" Set pa = .CreateParameter("@implemente_date", adDBTimeStamp, adParamInput)
.Parameters.Append pa
pa.value = RsFlights!implemente_date Set pa = .CreateParameter("@flight_date", adDBTimeStamp, adParamInput)
.Parameters.Append pa
pa.value = RsFlights!flight_date Set pa = .CreateParameter("@carr", adChar, adParamInput, 4)
.Parameters.Append pa
pa.value = RsFlights!carr Set pa = .CreateParameter("@flight_no", adChar, adParamInput, 5)
.Parameters.Append pa
pa.value = RsFlights!flight_no Set pa = .CreateParameter("@enter_time", adDBTimeStamp, adParamInput)
.Parameters.Append pa
pa.value = RsFlights!enter_time Set pa = .CreateParameter("@agent", adChar, adParamInput, 8)
.Parameters.Append pa
pa.value = RsFlights!agent Set pa = .CreateParameter("@success", adInteger, adParamOutput)
.Parameters.Append pa .Execute
IntReturn = cmd("@success")
End With
第一次成功,但是到第二次就提示:
"Too many arguments were supplied for procedure sp_protected_au"
请那位能诊断一下不胜感谢!
解决方案 »
- 求解关于VB 中 24位图像像素格式的问题
- 用inet的GetChunk方法抓取网页,中文容易出现乱码..
- 用VB6 winsock/ado等实现的一个自动处理程序,能不能转成后台服务
- 有关模式窗口的问题!!!
- 我下载了个李洪根大哥的局域网消息发送器,但一发送就提示找不到NETAPI32.DLL?
- recordset的问题
- 那位高手,救命亚,明天老师要检查,可是我做的程序出拉问题,救我一救
- insert into语法错误
- 这些贴子我挂了好久没人回答,但今天晚上10点我将结贴,关注者有分!(共340分)
- sql 语句中不能使用自定义函数吗?
- 如何判定是否有回车
- 怎样让一个MDI窗口的指定子窗口永远居前?
msn:[email protected]