新手提问

[A41854776]

sql="delete a where order_id='"&trim(b)&"'"
set objRS=objConn.execute(sql)
报这样一个错
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] 语法错误 (操作符丢失) 在查询表达式 'a where a_id='１'' 中
为什么呀，要怎么做呀，（Access数据库）

[littlelam]

sql="delete * from [tablename] where order_id="&trim(b)

[A41854776]

top

[51one]

sql="delete * from [tablename] where order_id='"&trim(b)&"'"