谁会在VBS中写带变量的SQL语句 点击：641 | 回复：8
发表于：2007-09-28 20:30:00
5楼
随便给你几个例子：
strSQL = "SELECT Top 1 * FROM Table_AndonStyle_Style_Config WHERE (AndonID = "&AndonNum.read&") ORDER BY SetupTime desc"
strSQL = "Update Table_Board_OnOff Set Enable = " &Enable& " ,OnTime = '" & HMIRuntime.Tags ("SCHE_V_BoardOn").Read & "'," + _
"OffTime = '" & HMIRuntime.Tags ("SCHE_V_BoardOff").Read& "', NextDay = " &NextDay& " " + _
"where ShiftID = " & ShiftID
strSQL = "SELECT Top 1 * FROM Table_AndonStyle_Style_Config WHERE (AndonID = "&AndonNum.read&") ORDER BY SetupTime desc"
strSQL = "Update Table_Board_OnOff Set Enable = " &Enable& " ,OnTime = '" & HMIRuntime.Tags ("SCHE_V_BoardOn").Read & "'," + _
"OffTime = '" & HMIRuntime.Tags ("SCHE_V_BoardOff").Read& "', NextDay = " &NextDay& " " + _
"where ShiftID = " & ShiftID
发表于：2007-09-28 20:31:00
6楼
再来一个更长的
strSQL="Insert Table_QDSK_Configure (SetupTime,QDSKID,Description,Station,ButtonID," _
& "ButtonName,InputAddress,OutputAddress,AndonBoard1,AndonBoard2,AndonBoard3," _
& "Lamp11,Lamp21,Lamp31,Color,Music,MusicTime,MusicClass) Values ('" _
& sTime & "','" & i+1 & "','" & sPubQDDesc(i) & "','" & sPubQDSTN(i) & "','" _
& j+1 & "','" & sPubQDBTDesc(i,j) & "','" & iPubQDIAddr(i,j) & "','" _
& iPubQDOAddr(i,j) & "','" & iPubQDABorad1(i,j) & "','" & iPubQDABorad2(i,j) & "','" _
& iPubQDABorad3(i,j) & "','" & iPubQDLamp11(i,j) & "','" & iPubQDLamp21(i,j) & "','" _
& iPubQDLamp31(i,j) & "','" & iPubQDColor(j) & "','" & iPubQDMu(i,j) & "','" _
& iPubQDMuTi(i,j) & "','" & iPubQDMuCl(j) & "')"
strSQL="Insert Table_QDSK_Configure (SetupTime,QDSKID,Description,Station,ButtonID," _
& "ButtonName,InputAddress,OutputAddress,AndonBoard1,AndonBoard2,AndonBoard3," _
& "Lamp11,Lamp21,Lamp31,Color,Music,MusicTime,MusicClass) Values ('" _
& sTime & "','" & i+1 & "','" & sPubQDDesc(i) & "','" & sPubQDSTN(i) & "','" _
& j+1 & "','" & sPubQDBTDesc(i,j) & "','" & iPubQDIAddr(i,j) & "','" _
& iPubQDOAddr(i,j) & "','" & iPubQDABorad1(i,j) & "','" & iPubQDABorad2(i,j) & "','" _
& iPubQDABorad3(i,j) & "','" & iPubQDLamp11(i,j) & "','" & iPubQDLamp21(i,j) & "','" _
& iPubQDLamp31(i,j) & "','" & iPubQDColor(j) & "','" & iPubQDMu(i,j) & "','" _
& iPubQDMuTi(i,j) & "','" & iPubQDMuCl(j) & "')"
热门招聘
相关主题
- WinCC 6.0+SP2 中文版 下...
[2593] - SIAVIEW工业控制监控系统系列...[2381]
- S7-200 PLC仿真软件 免费软...[4601]
- 组态王和Ｓ７２００的通讯问题...[2919]
- 三菱PLC与编码器问题[3701]
- 稳定可靠 全面冗余[2775]
- 三菱PLC仿真软件GX Simulato...[3396]
- 各位朋友，现实中实际问题拿来...[3523]
- 哪里有三菱F930GOT-BWD-C触摸...[5814]
- intouch 2012 ，传说中intouc...[5197]
官方公众号
智造工程师
-
客服
-
小程序
-
公众号
工控网智造工程师好文精选
