在全局脚本--动作 中用VBS写了个向数据库写入数据的代码,如下:
Option Explicit
Function action
Dim sCon
Dim sSql
Dim oRs
Dim conn
Dim oCom
Dim Con
Dim Data1, Data2
Data1=HMIRuntime.tags("press").read
Data2=HMIRuntime.tags("temp").read
Con="Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=DBTEST;Data Source=.\WINCC"
Set conn = CreateObject("ADODB.Connection")
conn.ConnectionString = Con
conn.CursorLocation = 2
conn.Open
sSql="insert into value VALUES('" & Data1 & "','" & Data2&"');"
Set oRs = CreateObject("ADODB.Recordset")
Set oCom = CreateObject("ADODB.Command")
Set oCom.ActiveConnection = conn
oCom.CommandType = 1
oCom.CommandText = sSql
Set oRs = oCom.Execute
Set oRs = Nothing
conn.Close
Set conn = Nothing
End Function
按照周期2秒执行,但是在数据库中数据没有写入,但是使用按钮动作的话,却可以写入,为什么?