All pastes #184784 Raw Edit

Unnamed

public text v1 · immutable
#184784 ·published 2006-09-28 09:04 UTC
rendered paste body
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;