在WinCC中如何访问数据库(VBS)
一、声名全局变量
在全局脚本中声明全局变量,如下:Public gocn
2、建立连接,如下:
Set gocn = CreateObject("ADODB.Connection")
gocn.open "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist
Security Info=False;Initial Catalog=GJS_SY;Data Source=LGL"
3、执行代码。例如插入一条记录:
gocn.Execute "insert into TB_FJ_DATA(LSH,GKH,T_time)
VALUES('1',99,GETDATE( ))"
二、访问数据记录和查询
1、查询。代码如下:On Error Resume Next
Dim NoOfRecords
Set NoOfRecords = HMIRuntime.Tags("NoOfRecords")
Dim CurrentRec
Set CurrentRec = HMIRuntime.Tags("CurrentRec")
Dim AuthorID
Set AuthorID = HMIRuntime.Tags("Au_ID")
Dim AuthorFirstName
Set AuthorFirstName = HMIRuntime.Tags("AuthorFirstName")
Dim Au