有句语法错误,能帮我看一下吗?

小清　发表于：2008-12-24 17:58:03 　

有句语法错误,能帮我看一下吗?

CurrentDb.Execute "update tblCTRSTATUS set ORDEROUTNO='" & Me.ORDEROUTNO & "',ORDEROUT=#" & Me.ORDEROUT & "#,EXSHIPPER='" & Me.EXSP & "',SEAL='" & Me.SEAL & "',POD='" & Me.POD & "',DEST='" & Me.DEST & "',ILV='" & Me.ILV & "',SHIPPER='" & Me.SHIPPER & "',OCONSIGNEE='" & Me.OCONSIGNEE & "',COMMODITY='" & Me.COMMODITY & "',ORDERSTATUS=-1 , ALL=-1 where LINER='" & Me.cline & "'"

错误提示为"UPDATE陈述句的语法错误"

之前可以的，我加了，ALL=-1 之后就出现错误了

谢谢

Top

ACMAIN.CHM 发表于：2008-12-24 19:24:46

在前面加一句

debug.print "update tblCTRSTATUS set ORDEROUTNO='" & Me.ORDEROUTNO & "',ORDEROUT=#" & Me.ORDEROUT & "#,EXSHIPPER='" & Me.EXSP & "',SEAL='" & Me.SEAL & "',POD='" & Me.POD & "',DEST='" & Me.DEST & "',ILV='" & Me.ILV & "',SHIPPER='" & Me.SHIPPER & "',OCONSIGNEE='" & Me.OCONSIGNEE & "',COMMODITY='" & Me.COMMODITY & "',ORDERSTATUS=-1 , ALL=-1 where LINER='" & Me.cline & "'"

看看SQL语句的内容是什么。这样你就可以自己找出问题所在了。

Top

金宇发表于：2008-12-24 23:36:01

[all]=-1试试呢

Top

总记录：2篇页次：1/1 9 1 :

Access交流中心

有句语法错误,能帮我看一下吗?