7,763
社区成员
发帖
与我相关
我的任务
分享
Public cn As New ADODB.Connection
Public rs As New ADODB.Recordset
Public sql As String
Private Sub Timer1_Timer()
Call ReadDA100(m_GetDA100(), COM1) '采集DA100
cn.Open "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + App.Path & "\数据库\" & bisoshi & ".accdb" & ";Jet OlEDB:Database "
sql = "select * from" & " " & biaoshi & " order by 测试时间 asc"
rs.Open sql, cn, 1, 3
rs.AddNew
rs.Fields(0) = time_start(j, i)
rs.Fields(1) = Format(Now, "yyyy/mm/dd hh:mm:ss")
rs.Fields(2) = strQiHouLeiXing
rs.Fields(3) = strHuanJingWenDu(j, i)
rs.Update
rs.Close
Set rs = Nothing
cn.Close
Set cn = Nothing
End Sub
Public cn As ADODB.Connection 'New 去除
Public rs As ADODB.Recordset 'New 去除
Public sql As String
Private Sub Timer1_Timer()
Call ReadDA100(m_GetDA100(), COM1) '采集DA100
set cn=new ADODB.Connection
cn.Open "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + App.Path & "\数据库\" & bisoshi & ".accdb" & ";Jet OlEDB:Database "
sql = "select * from" & " " & biaoshi & " order by 测试时间 asc"
set rs=new ADODB.Recordset
rs.Open sql, cn, 1, 3
rs.AddNew
rs.Fields(0) = time_start(j, i)
rs.Fields(1) = Format(Now, "yyyy/mm/dd hh:mm:ss")
rs.Fields(2) = strQiHouLeiXing
rs.Fields(3) = strHuanJingWenDu(j, i)
rs.Update
rs.Close
Set rs = Nothing
cn.Close
Set cn = Nothing
End Sub