Function function2()
Private Declare Sub Sleep Lib "kernel32 " (ByVal dwMilliseconds As Long)
Dim p As IntegerSet cn = New ADODB.Connection
Set rs = New ADODB.Recordset
cn.Open ("Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=独占设备;Data Source=PC-20110915FGKA")
sql = "select * from PROCESS where jczhuangtai=0"
rs.Open sql, cn, 1, 3
rs.MoveFirst
p = 0
Do While rs.EOF = False
cn.Execute "update DCT set zhuangtai=0 where zhuangtai=1"
cn.Execute "update COCT set zhuangtai1=0 where zhuangtai1=1"
cn.Execute "update CHCT set zhuangtai2=0 where zhuangtai2=1"
Adodc8.Recordset.Requery
Adodc9.Recordset.Requery
Adodc14.Recordset.Requery
Sleep 2000
Call function1
Sleep 2000
rs.MoveNext
Loop
End Function
第二句出错了,第二句应该放在哪?请指教下,谢谢!
Private Declare Sub Sleep Lib "kernel32 " (ByVal dwMilliseconds As Long)
Dim p As IntegerSet cn = New ADODB.Connection
Set rs = New ADODB.Recordset
cn.Open ("Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=独占设备;Data Source=PC-20110915FGKA")
sql = "select * from PROCESS where jczhuangtai=0"
rs.Open sql, cn, 1, 3
rs.MoveFirst
p = 0
Do While rs.EOF = False
cn.Execute "update DCT set zhuangtai=0 where zhuangtai=1"
cn.Execute "update COCT set zhuangtai1=0 where zhuangtai1=1"
cn.Execute "update CHCT set zhuangtai2=0 where zhuangtai2=1"
Adodc8.Recordset.Requery
Adodc9.Recordset.Requery
Adodc14.Recordset.Requery
Sleep 2000
Call function1
Sleep 2000
rs.MoveNext
Loop
End Function
第二句出错了,第二句应该放在哪?请指教下,谢谢!
解决方案 »
- VB中进行合并Excel单元格操作后,不能正常释放(关闭)Excel进程的解决办法(Excel.Range的正确使用方法)
- 每次编译都出现这样的错误“device i/o error” 急
- COMDLG32.OCX的奇怪问题
- 磁盘空间的API函数
- 请教VB调用EXCEL生成报表的问题!
- 谁敢进来?
- 求助!!帮忙就一定给分!VB中怎样管理Win2000的用户和组?
- 使用ODBC API SDK 怎样在VB中建立数据源?请高手指点!
- 小弟问:如何设公用变量?(就是在所有情况下值不会丢的那种?)
- vba 实现excel自动填充列值
- split被报毒!什么情况?
- 【求助】VB对象删除出错,各位出招。。。。。
Function function2()
我把这个声明放到你们说的前面还是function2后一句,一样会出现编译错误:在end sub,end function或end属性后面只能出现注释 的提示
放到“通用”的“声明”中去吧
放入一个标准模块中去~~~