代码如下
str6 = "insert into yuanshi01(xuhao,riqi,shijian,zhujiao,beijiao,opc,dpc,dianlu,cic,jieguo,xiangying,shichang,col013)values('" + ss1 + "','" + ss2 + "','" + ss3 + "','" + ss4 + "','" + ss5 + "','" + ss6 + "','" + ss7 + "','" + ss8 + "','" + ss9 + "','" + ss10 + "','" + ss11 + "','" + ss12 + "','" + ss13 + "')"
cmd1.ActiveConnection = conn
cmd1.CommandType = adCmdText
cmd1.CommandText = str6
cmd1.Execute提示我的sql语句过长,好像是sql命令不能超过128个字符,有什么办法解决?
str6 = "insert into yuanshi01(xuhao,riqi,shijian,zhujiao,beijiao,opc,dpc,dianlu,cic,jieguo,xiangying,shichang,col013)values('" + ss1 + "','" + ss2 + "','" + ss3 + "','" + ss4 + "','" + ss5 + "','" + ss6 + "','" + ss7 + "','" + ss8 + "','" + ss9 + "','" + ss10 + "','" + ss11 + "','" + ss12 + "','" + ss13 + "')"
cmd1.ActiveConnection = conn
cmd1.CommandType = adCmdText
cmd1.CommandText = str6
cmd1.Execute提示我的sql语句过长,好像是sql命令不能超过128个字符,有什么办法解决?
conn.Execute str6
先inster一半再inster另外一半喽
没有错误!
但是在VB里面使用就不行。
分开insert,不就insert 成2行了吗
Debug.Print str6
strline1 = "1 2006-06-11 08:59:59 13387192819 3544119 JZ联通IGW JZ电信GW1 13 22 [16H]计费应答次数( 707 52 "
ss1 = Mid(strline1, 1, 9)
ss2 = Mid(strline1, 10, 11)
ss3 = Mid(strline1, 21, 12)
ss4 = Mid(strline1, 33, 21)
ss5 = Mid(strline1, 54, 21)
ss6 = Mid(strline1, 75, 11)
ss7 = Mid(strline1, 86, 11)
ss8 = Mid(strline1, 97, 7)
ss9 = Mid(strline1, 104, 7)
ss10 = Mid(strline1, 111, 21)
ss11 = Mid(strline1, 131, 12)
ss12 = Mid(strline1, 150, 14)
ss13 = Mid(strline1, 160, 2)如果改为,则执行没有问题
ss1 = "1234"
ss2 = "2345"
ss3 = "3456"
ss4 = "4567"
ss5 = "5678"
ss6 = "6789"
ss7 = "7890"
ss8 = "8901"
ss9 = "9012"
ss10 = "0123"
ss11 = "11234"
ss12 = "22345"
ss13 = "33456"不知道为什么
这里假定rs是一个Ado.recordset
rs.Addnew
rs(0)=trim(text1)文本框内容
rw(1)=trim(text2)
......
rs.update
......
ss1 = Mid(strline1, 1, 9)
......
ss13 = Mid(strline1, 160, 2)
Debug.Print ss1
......
Debug.Print ss13
谢谢大家!