我用SQL 的更新语句
当我加上WHERE时 不能更新
不加时 就全部更新
你说怎么办呢? 我的SQL语句是
Dim sql As String
sql = "update provider set" & " mingcheng2=" & "'" & mingcheng1 & "'," & "yingwenming2=" & "'" & yingwenming1 & "'," & "dizhi2=" & "'" & dizhi1 & "'," & "fangshi2=" & "'" & fukuanfangshi1 & "'," & "dianhua2=" & "'" & dianhua1 & "'," & "chuanzhen2=" & "'" & chuanzhen1 & "'," & "lianxiren2=" & "'" & lianxiren1 & "'," & "youxiang2=" & "'" & youxiang1 & "'" & "where bianma2="&"'" & bianma1 & "'"
denglu.conn.Execute sql
语句应该是正确的 请问问题在哪了?
当我加上WHERE时 不能更新
不加时 就全部更新
你说怎么办呢? 我的SQL语句是
Dim sql As String
sql = "update provider set" & " mingcheng2=" & "'" & mingcheng1 & "'," & "yingwenming2=" & "'" & yingwenming1 & "'," & "dizhi2=" & "'" & dizhi1 & "'," & "fangshi2=" & "'" & fukuanfangshi1 & "'," & "dianhua2=" & "'" & dianhua1 & "'," & "chuanzhen2=" & "'" & chuanzhen1 & "'," & "lianxiren2=" & "'" & lianxiren1 & "'," & "youxiang2=" & "'" & youxiang1 & "'" & "where bianma2="&"'" & bianma1 & "'"
denglu.conn.Execute sql
语句应该是正确的 请问问题在哪了?
当我加上WHERE时 不能更新
不加时 就全部更新
你说怎么办呢? 我的SQL语句是
----------------------------------------
看的眼花,&用的太多了sql = "update provider set mingcheng2='" & mingcheng1 & "',......where bianma2='" & bianma1 & "'"字符串连接变量,字符串和变量之间加&号加上WHERE就不能执行,那肯定是没有符合条件的数据
看看你字段bianma2的数据类型,如果是int类型:
",......where bianma2=" & bianma1
这样就可以了或者你在查询分析中,直接给bianma2赋一个具体的值,看看有没有问题