X
xiaocai
Unregistered / Unconfirmed
GUEST, unregistred user!
经过实验,更怪的问题,用同样一句,在VFP里可以执行,在DELPHI的Query里就不能执行,大家帮忙看看
delete from source where sale_date<='+formatdatetime('{^yyyy-mm-dd}',datetimepicker1.Date)
这句SQL到了query里变为delete from source where sale_date<={^2006-01-01}在VFP里执行得可好了,可是到了delphi里报General SQL error,不会吧!大家帮忙看看,急啊,调了一天了。
delete from source where sale_date<='+formatdatetime('{^yyyy-mm-dd}',datetimepicker1.Date)
这句SQL到了query里变为delete from source where sale_date<={^2006-01-01}在VFP里执行得可好了,可是到了delphi里报General SQL error,不会吧!大家帮忙看看,急啊,调了一天了。