用参数: with query1 do begin close; sql.clear; sql.add('select * from myTable where time>=:aa and time<=:bb'); paramByName('aa').asDateTime:=strToDate('1999-1-1'); paramByName('bb').asDateTime:=strToDate('2000-12-31'); open; end;如果是ADOQuery1,用 ADOQuery1.parameters.paramByName('aa).asDateTime:=...
with query1 do
begin
close;
sql.clear;
sql.add('select * from myTable where time>=:aa and time<=:bb');
paramByName('aa').asDateTime:=strToDate('1999-1-1');
paramByName('bb').asDateTime:=strToDate('2000-12-31');
open;
end;如果是ADOQuery1,用
ADOQuery1.parameters.paramByName('aa).asDateTime:=...