Private Sub Command1_Click()
Dim conn As ADODB.Connection
Dim sql As String
Dim addr As String
Dim sbmc As String
Dim yzqk As String
Dim gzdd As String
Dim jksbgzjl As String
Dim fssj As String
Dim zcsj As String
Dim clqk As String
Dim fzr As String
Set conn = New ADODB.Connection
constr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=F:\fxj\VB\rizhi.mdb;Persist Security Info=False"
conn.ConnectionString = constr
conn.Open constr
addr = Me.Text1(1).Text
ssbmc = Me.Text1(2).Text
yzqk = Me.Text1(3).Text
gzdd = Me.Text1(4).Text
jksbgzjl = Me.Text1(5).Text
fssj = Me.Text1(6).Text
zcsj = Me.Text1(7).Text
clqk = Me.Text1(8).Text
fzr = Me.Text1(9).Text
sql = "insert into jk(地点,设备名称,运转情况,故障地点,监控设备故障记录,发生时间,正常时间,处理情况,负责人,) values ('" + addr "','" sbmc + "','" yzqk + "','" gzdd + "','" jksbgzjl + "','" fssj + "','" zcsj + "','" clqk + "','" fzr + "',)"
conn.Execute sql
他提示我SQL语句不对,怎么写SQL的格式
Dim conn As ADODB.Connection
Dim sql As String
Dim addr As String
Dim sbmc As String
Dim yzqk As String
Dim gzdd As String
Dim jksbgzjl As String
Dim fssj As String
Dim zcsj As String
Dim clqk As String
Dim fzr As String
Set conn = New ADODB.Connection
constr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=F:\fxj\VB\rizhi.mdb;Persist Security Info=False"
conn.ConnectionString = constr
conn.Open constr
addr = Me.Text1(1).Text
ssbmc = Me.Text1(2).Text
yzqk = Me.Text1(3).Text
gzdd = Me.Text1(4).Text
jksbgzjl = Me.Text1(5).Text
fssj = Me.Text1(6).Text
zcsj = Me.Text1(7).Text
clqk = Me.Text1(8).Text
fzr = Me.Text1(9).Text
sql = "insert into jk(地点,设备名称,运转情况,故障地点,监控设备故障记录,发生时间,正常时间,处理情况,负责人,) values ('" + addr "','" sbmc + "','" yzqk + "','" gzdd + "','" jksbgzjl + "','" fssj + "','" zcsj + "','" clqk + "','" fzr + "',)"
conn.Execute sql
他提示我SQL语句不对,怎么写SQL的格式
解决方案 »
- 想做一个开板的小软件,请大虾提供思路和算法?
- 在VB中如何对Access数据库创建查询?
- 难难的两个问题!!
- 求ActiveReport Pro2.0 SP
- 麻烦,高手进来看一下,这是为什么啊!!
- 有谁用过resize32.ocx控件?
- please help me!
- DBGRID1控件问题
- crystal report问题,望名位大哥帮帮小弟。
- 如何控制声道的转换。最起码要实现左声道、右声道、和立体声三种转换。比如看VCD时,左右声道是两种语言。就好像国语和粤语。用的是mmcontrol多媒体控件。最好写出代码。
- excel中打印条形码的问题
- 新下载的DNSLookUp.ocx控件,使用时报错,请高手解答一下,谢谢。(我只有30分了)
1。每个嵌入的变量两侧都要有运算符
2。vb中字符串连接符我用 &
3。最后多了个逗号
先修改如下:
sql = "insert into jk(地点,设备名称,运转情况,故障地点,监控设备故障记录,发生时间,正常时间,处理情况,负责人,) values ('" & addr & "','" & sbmc & "','" & yzqk & "','" & gzdd & "','" & jksbgzjl & "','" & fssj & "','" & zcsj & "','" & clqk & "','" & fzr & "')"
在程序调适中在sql后面加一个断点,程序运行到此了之后。在下面的立即窗口打入 ?sql 按回车就会显示这个sql的语句,好好检查一下就能看出不对了
&"监控设备故障记录,发生时间,正常时间,处理情况,负责人)" _
&" values ('" & addr & "','" & sbmc & "','" & yzqk & "','" _
& gzdd & "','" & jksbgzjl & "','" & fssj & "','" & zcsj & "','" _
& clqk & "','" & fzr & "')"呵呵,这样写怎样?