SQL Server 中Update的问题？

[giszj]

本人用ADO连接了Sql server后，要对表A中符合条件的记录的字段X的值更改
如下：
dim con as new adodb.connection
....
dim str as string
dim mysql as string
str="myvalue"
mysql="update A set x=" & str & "2" & "where x=" str
con.execute mysql
问题来了：
程序老是提示”列名myvalue2无效？！“
天哪我的值怎么成了列名了呢？
即窗口中的值：update A set x=myvalue2 where x=myvalue
怎么不是：update A set x='myvalue2' where x='myvalue'
请问究竟是怎么回事啊？如何解决这个问题呢？

[wtadminxjeri]

字符类型的值更新要加单引号,你的更新语句放到查询分析器就成为以下的句子了
-----------------------------------------
update A set x= myvalue2 where x=myvalue

[99831323]

mysql="update A set x=" & str & "2" & "where x=" str
-->
mysql="update A set x='" & str & "2'" & "where x='" & str & "'"

你不给它加引号，它当然没引号

[zjcxc]

dim con as new adodb.connection
....
dim str as string
dim mysql as string
str="myvalue"
mysql="update A set x='" & str & "2'" & "where x='" str & "'" --你自己少写了嘛
con.execute mysql

[wtadminxjeri]

Dim str As String
Dim mysql As String
str = "myvalue"
mysql = "update A set x='" & str & "2" & "' where x='" & str & "' "