Private Sub Command1_Click()
Dim cn As New ADODB.Connection
Dim cmd As New ADODB.Command
Dim paramPlantCode As ADODB.Parameter
Dim rs As New ADODB.Recordset
cn.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Password=sa;Initial Catalog=bic;Data Source=192.168.0.4"
cn.Open
cmd.ActiveConnection = cn
cmd.CommandText = "bic_ii_stockcount"
cmd.CommandType = adCmdStoredProc
cmd.CommandTimeout = 1000 Set paramPlantCode = cmd.CreateParameter("modellcode", adChar, adParamInput, 2, "01")
cmd.Parameters.Append paramPlantCode
Set rs = cmd.Execute()
While Not rs.EOF'到这里的时候报告3704错误:对象已关闭,不允许操作.
rs.MoveNext
Wend
End Sub上面while 时出错,原来好的。
奇怪
Dim cn As New ADODB.Connection
Dim cmd As New ADODB.Command
Dim paramPlantCode As ADODB.Parameter
Dim rs As New ADODB.Recordset
cn.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Password=sa;Initial Catalog=bic;Data Source=192.168.0.4"
cn.Open
cmd.ActiveConnection = cn
cmd.CommandText = "bic_ii_stockcount"
cmd.CommandType = adCmdStoredProc
cmd.CommandTimeout = 1000 Set paramPlantCode = cmd.CreateParameter("modellcode", adChar, adParamInput, 2, "01")
cmd.Parameters.Append paramPlantCode
Set rs = cmd.Execute()
While Not rs.EOF'到这里的时候报告3704错误:对象已关闭,不允许操作.
rs.MoveNext
Wend
End Sub上面while 时出错,原来好的。
奇怪
解决方案 »
- vb利用SendMessage操作listview居然失败,太怪异了!!
- VB6.0的Datagrid1修改时报“ 无法为更新定位行,一些值可能已在最后一次读取后更改”
- 求解:如何将一个外部程序运行在自己的窗口中?
- 投票:你是否同意回复clear_zero的VB版主职位。
- 如果想往MSFLEXGRID指定行后面插入新的一行,应该怎么做?
- 请问怎样声明参数是关键字的API???
- zqfleaf!请帮帮忙!!(在线)
- 有什么方法可以在程序里往资源文件(*.res)里加入数据!如:有loadresstring方法读数据,有没有相对应的方法插入数据??
- VB数组问题
- 帮忙??
- vb如何实现文件的粘贴
- 急需自动提交的实现方法!!
@modellcode varchar(10)
AS
declare @tempdate datetime
create table #t(d datetime, s int)
declare cdw cursor for
select wdays from workcalendar where year(wdays)=year(getdate()) and month(wdays)=month(getdate())
and day(wdays)<=day(getdate()) and working=1 order by wdays
open cdw
fetch next from cdw into @tempdate
while @@fetch_status=0
begin
insert into #t (d,s)
select top 1 @tempdate as td, stockcount from stock
where stockdate<=@tempdate and modellcode=@modellcode
order by td desc
fetch next from cdw into @tempdate
end
close cdw
deallocate cdw
select * from #t order by d
drop table #t
GO
应该没问题,我在查询分析器中执行过,有结果的
@modellcode varchar(10)
AS/*加上一句:*/
SET NOCOUNT ON
....
....