表格db中,存在一个日期型的字段Date,现在需要更新,有如下语句,执行后出错:
"Syntax error in update statement",估计是日期型这里出问题了,请大伙帮忙看看,谢谢 Dim oConn As New ADODB.Connection
oConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\db.mdb"
oConn.Open
oConn.BeginTrans
oConn.Execute "Update db Set Date = '2003/10/21' Where ID = 12"
oConn.CommitTrans
"Syntax error in update statement",估计是日期型这里出问题了,请大伙帮忙看看,谢谢 Dim oConn As New ADODB.Connection
oConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\db.mdb"
oConn.Open
oConn.BeginTrans
oConn.Execute "Update db Set Date = '2003/10/21' Where ID = 12"
oConn.CommitTrans
解决方案 »
- 怎样得到API函数ShellExecute执行完毕?
- 数据库删除数据时出现的错误
- 选中combox中选项后让其它控件相应,用哪个事件?是click,dragover,dragdown...?
- 请教
- 1000 元 求助, 解决 删除 IE 自动完成 (autocomplete) 历史记录
- 50分送朋友!如何读取一个*.DBF文件中的数据
- VB连接access2000的问题
- 有没有一本介绍第三方ActiveX控件的书?
- 请问有谁知道怎样只用win或alt键做热键的方法(就像在windows中单击win键就弹出开始菜单一样)!问题解决即加分!谢谢!
- 如何用readline读文件
- vsflexgrid控件的输入法问题
- 数据库统计问题
Dim oConn As New ADODB.Connection
oConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\db.mdb"
oConn.Open
oConn.BeginTrans
oConn.Execute "Update db Set Date = '2003-10-21' Where ID = 12"
oConn.CommitTrans
2:好象没必要启动事务吧
Dim oConn As New ADODB.Connection
oConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\db.mdb"
oConn.Open
oConn.Execute "Update db Set Date = '2003-10-21' Where ID = 12"
oConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\db.mdb"
oConn.Open
oConn.Execute "Update [db] Set [Date] = '2003-10-21' Where [ID] = 12"
改成:oConn.Execute "Update db Set [Date] = '2003-10-21' Where ID = 12"
它们要包含在##之间