SQL-запрос в диапазоне

unit Unit1;
 
interface
 
uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, DB, ADODB, Grids, DBGrids, StdCtrls, ComCtrls, ExtCtrls, DBCtrls;
 
type
  TForm1 = class(TForm)
    DataSource1: TDataSource;
    DBGrid1: TDBGrid;
    ADOQuery1: TADOQuery;
    ADOConnection1: TADOConnection;
    qVerify: TADOQuery;
    Panel1: TPanel;
    DateTimePicker1: TDateTimePicker;
    DateTimePicker2: TDateTimePicker;
    Button1: TButton;
    Panel2: TPanel;
    DBNavigator1: TDBNavigator;
    Button2: TButton;
    procedure Button1Click(Sender: TObject);
    procedure FormCreate(Sender: TObject);
    procedure Button2Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;
 
var
  Form1: TForm1;
 
implementation
 
{$R *.dfm}
 
function DateToSQLStr(Date : TDate) : String ;
   var
      d, m, y : word ;
begin
   DecodeDate(Date, y, m, d) ;
   Result := IntToStr(d)+'/'+IntToStr(m)+'/'+IntToStr(y) ;
end ;
 
procedure TForm1.Button1Click(Sender: TObject);
begin
   qVerify.SQL.Text := 'SELECT * FROM касса WHERE [дата] between #' + DateToSQLStr(DateTimePicker1.Date) + '# and #' + DateToSQLStr(DateTimePicker2.Date) +'#' ;
   qVerify.Open ;
   if qVerify.IsEmpty then begin
      Application.MessageBox('Записи отсутствуют!', 'Информация', MB_ICONINFORMATION) ;
   end
   else begin
      ADOQuery1.SQL.Text := qVerify.SQL.Text ;
      ADOQuery1.Open ;
   end;
end ;
 
procedure TForm1.FormCreate(Sender: TObject);
begin
   ADOQuery1.SQL.Text := 'SELECT * FROM касса' ;
   ADOQuery1.Open ;
end;
 
procedure TForm1.Button2Click(Sender: TObject);
begin
   ADOQuery1.SQL.Text := 'SELECT * FROM касса' ;
   ADOQuery1.Open ;
end;
 
end.