var
vstartdate, venddate :string;
begin
vstartdate := edit1.Text + '-1-1';
venddate := edit1.text + '-12-31';
with Query1 do
begin
Close;
SQL.Clear;
SQL.Add('select * from table where date between :startdate and :enddate');
ParamByName('startdate').AsString := vstartdate;
ParamByName('enddate').AsString := vEndDate;
try
Open;
//其它处理
except
//异常处理部分
end;
end;
end;