我用的是ACCESS数据库,在DELPHI6.0中,用SQL EXPLORE 可以运行下面的语句
delete * from jcydata where dwmc='泉州变' and byqmc='2#联变B相' and jcyxh='N-TCG-6C' and datasj =#2004-11-01 17:04:15#
但在程序中运行下面的语句出错 sqlstr := 'delete * from jcydata where dwmc='泉州变' and byqmc='2#联变B相' and jcyxh='N-TCG-6C' and datasj =#2004-11-01 17:04:15#'
temadoquery.sql.clear;
temadoquery.sql.add(sqlstr);
temadoquery.execsql;
请问是什么原因?
delete * from jcydata where dwmc='泉州变' and byqmc='2#联变B相' and jcyxh='N-TCG-6C' and datasj =#2004-11-01 17:04:15#
但在程序中运行下面的语句出错 sqlstr := 'delete * from jcydata where dwmc='泉州变' and byqmc='2#联变B相' and jcyxh='N-TCG-6C' and datasj =#2004-11-01 17:04:15#'
temadoquery.sql.clear;
temadoquery.sql.add(sqlstr);
temadoquery.execsql;
请问是什么原因?
temadoquery.ParamCheck:=False;
语法错误
还有时间参数 #2004-11-01 17.04.15#'
或者
#2004-11-01 17::04::15#