procedure TForm1.Filter_Date_TimeClick(Sender: TObject); var start_datum : string; end_datum : string; start_ido : string; end_ido : string; formatum : TFormatSettings; formatum_datum : TFormatSettings; begin formatum_datum.DateSeparator:='.'; formatum_datum.LongDateFormat:='yyyy.mm.dd'; formatum_datum.ShortDateFormat:='yyyy.MM.dd'; formatum.TimeSeparator:=':'; formatum.LongTimeFormat:='hh:nn'; formatum.ShortTimeFormat:='HH:mm'; start_datum:=datetostr(DateTimePicker3.Date,formatum_datum); end_datum:=datetostr(DateTimePicker4.Date,formatum_datum); start_ido:=timetostr(DateTimePicker1.Time,formatum); end_ido:=timetostr(DateTimePicker2.Time,formatum); if start_ido>end_ido then begin // AdoQuery1.SQL.Add('SELECT * FROM cardmanager WHERE Bolt_nev='+QuotedStr(bolt_valaszt)+' and (Datum >= '+QuotedStr(start_datum)+' and Datum <= '+QuotedStr(end_datum)+') and (Ido >= '+QuotedStr(start_ido)+' or Ido <= '+QuotedStr(end_ido)+')') AdoQuery1.Filter:='Bolt_nev= '+QuotedStr(bolt_valaszt)+' and (Datum >= '+QuotedStr(start_datum)+' and Datum <= '+QuotedStr(end_datum)+') and (Ido >= '+QuotedStr(start_ido)+' or Ido <= '+QuotedStr(end_ido)+')'; AdoQuery1.Filtered:=true; // AdoQuery1.Filter:='Bolt_nev= '+QuotedStr(bolt_valaszt)+' and (Datum >= '+QuotedStr(start_datum)+' and Datum <= '+QuotedStr(end_datum)+') and (Ido >= '+QuotedStr(start_ido)+' or Ido <= '+QuotedStr(end_ido)+')'; // AdoQuery1.Filtered:=true; end else begin // AdoQuery1.SQL.Add('SELECT * FROM cardmanager WHERE Bolt_nev='+QuotedStr(bolt_valaszt)+' and (Datum >= '+QuotedStr(start_datum)+' and Datum <= '+QuotedStr(end_datum)+') and (Ido >= '+QuotedStr(start_ido)+' and Ido <= '+QuotedStr(end_ido)+')'); AdoQuery1.Filter:='Bolt_nev= '+QuotedStr(bolt_valaszt)+' and (Datum >= '+QuotedStr(start_datum)+' and Datum <= '+QuotedStr(end_datum)+') and (Ido >= '+QuotedStr(start_ido)+' and Ido <= '+QuotedStr(end_ido)+')'; end; INFO_Lines.Text:=inttostr(AdoQuery1.RecordCount); end;