procedure TForm1.DateTimePicker1Change(Sender: TObject); begin with adoquery1 do begin close; sql.clear; sql.text := format('select * from a where f1 = ''%s'' ',[formatdateTime('YYYY-MM-DD',datetimepicker1.Date)]); open; end; end;
补充楼上的: 查询Access数据库: procedure TForm1.DateTimePicker1Change(Sender: TObject); begin with adoquery1 do begin close; sql.clear; sql.text := format('select * from a where f1 = #%s# ',[formatdateTime('YYYY-MM-DD',datetimepicker1.Date)]); open; end; end;
begin
with adoquery1 do
begin
close;
sql.clear;
sql.text := format('select * from a where f1 = ''%s'' ',[formatdateTime('YYYY-MM-DD',datetimepicker1.Date)]);
open;
end;
end;
查询Access数据库:
procedure TForm1.DateTimePicker1Change(Sender: TObject);
begin
with adoquery1 do
begin
close;
sql.clear;
sql.text := format('select * from a where f1 = #%s# ',[formatdateTime('YYYY-MM-DD',datetimepicker1.Date)]);
open;
end;
end;