文件名称:SQL写入数据案列视频.mp4
文件大小:3.95MB
文件格式:MP4
更新时间:2022-12-13 12:53:29
SQL
在写数据中写入如下脚本? Dim sCon Dim sSql Dim oRs Dim conn Dim oCom Dim Con Dim Data1 Data1=HMIRuntime.tags("A1").read Con="Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=master;Data Source=ms-20180905leze\wincc" Set conn=CreateObject("ADODB.Connection") conn.ConnectionString=Con conn.CursorLocation=3 conn.Open sSql="insert into TB1 VALUES('" & Data1 & "');" Set oRs=CreateObject("ADODB.Recordset") Set oCom=CreateObject("ADODB.Command") Set oCom.ActiveConnection=c