这样的语句错误在哪里啊?请帮忙指点更正!
Dim strsql1 As Stringstrsql = "delete KQBRUSH" & Trim(MEditBox9.Text) & "where skrq=" & Trim(MEditBox8.Text)
rs.Open strsql
rs.Close
MEditBox8.Text = "删除成功!" --------------------编程问答-------------------- rs是记录集?没有这么用的。
应该是 conn.execute(strsql) --------------------编程问答-------------------- strsql = "delete KQBRUSH " & Trim(MEditBox9.Text) & " where skrq=" & Trim(MEditBox8.Text)
注意加个空格防止MEditBox9.Text为空 --------------------编程问答-------------------- strsql = "delete KQBRUSH" & Trim(MEditBox9.Text) & "where skrq='" & Trim(MEditBox8.Text) & "'"
conn.excute strsql --------------------编程问答-------------------- delete from ......
SQL 语法错了吧?? --------------------编程问答-------------------- Sql语句测试
首先把所有的变量替换成常数 看看语句本身的语法有没错误
然后在把变量换上去测试
楼主的Sql语句看似有问题
delete KQBRUSH" & Trim(MEditBox9.Text) & "where skrq=" & Trim(MEditBox8.Text)
--------------------------------------------------------------------------------
delete tabTmp where field= VarTmp
难道lz的表名是KQBRUSH+Trim(MEditBox9.Text)么?
补充:VB , 基础类