日期:2014-05-18  浏览次数:20524 次

access删除语句删除不了
DELETE *
FROM AddFreon
WHERE StartTime = # 12-07-17 16:22:48 #
为什么删除不了内容,崩溃了!

------解决方案--------------------
SQL code
DELETE 
FROM AddFreon
WHERE StartTime = # 12-07-17 16:22:48 # 注:数据库中要有StartTime =# 12-07-17 16:22:48 #的行数

------解决方案--------------------
DELETE FROM AddFreon
WHERE StartTime = '12-07-17 16:22:48'

delete from 中间不加*
不知道你的#是时间字段里面的字符吗?
------解决方案--------------------
SQL code


DELETE 
FROM AddFreon
WHERE StartTime ='12-07-17 16:22:48'

------解决方案--------------------
探讨
SQL code


DELETE
FROM AddFreon
WHERE StartTime ='12-07-17 16:22:48'




你StartTime字段内容是 # 12-07-17 16:22:48 # ?