郁闷一下午 求助--- 提示update语法错误！！！！！！！！！！！！！！！！怎么办

[Dicky81]

Dim db1 As String = "data/hxyl.mdb"
Dim connstr1 As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(db)
Dim conn1 As New OleDbConnection(connstr1)
conn1.Open()
Dim upsql As String = "update news set count=count+1 where id=1"
Dim mycom1 As New OleDbCommand(upsql, conn1)
mycom1.ExecuteNonQuery()
conn1.Close()
运行时提示：update语法错误！怎么办,谢谢帮忙解答！！

[hedonister]

count=count+1 ?

这里错了吧？先用程序取出来，累加一再更新

[98star]

把字段count换成别的名字试一试

[Nils]

try:

update [news] set [count]=[count]+1 where id='1'

[Nils]

update [news] set [count]=[count]+1 where id=1

[kaiqiao521]

http://218.27.204.17/aspnet/Articles/ShowArticle.aspx?ArticleID=893

[cender]

update A_TABLE
set NAME = NAME || '1'
where COL_NAME = '1'
正常执行
NAME : VARCHAR2
COL_NAME : NUMBER
ORACLE 10G

[cender]

写错了
COL_NAME是VARCHAR2

[coldpanth]

数据库里的字段名还是像 N_count U_name这样命名比较好/.

[minghui000]

up