Delphi-PRAXiS
Seite 2 von 2     12   

Delphi-PRAXiS (https://www.delphipraxis.net/forum.php)
-   Datenbanken (https://www.delphipraxis.net/15-datenbanken/)
-   -   DBGrid filtering (https://www.delphipraxis.net/169829-dbgrid-filtering.html)

Bummi 15. Aug 2012 09:06

AW: DBGrid filtering
 
Delphi-Quellcode:
procedure TForm2.DatasetFilterRecord1(DataSet: TDataSet; var Accept: Boolean);
var
 f:TField;
begin
  f := Dataset.FieldByName('Firma');
    Accept := (Length(f.AsString)>0) and (f.AsString[1] <> 'A') and (f.AsString[1] <= 'D');
end;

procedure TForm2.DatasetFilterRecord2(DataSet: TDataSet; var Accept: Boolean);
var
 f:TField;
begin
  f := Dataset.FieldByName('Firma');
  Accept := (Length(f.AsString)>0) and (f.AsString[1] in ['B'..'D']);
end;

danten 15. Aug 2012 16:12

AW: DBGrid filtering
 
Liste der Anhänge anzeigen (Anzahl: 1)
OK,datamodule:
Delphi-Quellcode:
procedure Tdm.tab_dodavatelFilterRecord(DataSet: TDataSet; var Accept: Boolean);
var
 f:TField;
begin
  f := Dataset.FieldByName('Firma');
  Accept := (Length(f.AsString)>0) and (f.AsString[1] > frm_export.sEdit1.Text) and (f.AsString[1] <= frm_export.sEdit2.Text);
end;
MainForm:
Delphi-Quellcode:
procedure Tfrm_export.sButton1Click(Sender: TObject);
var
  Accept: boolean;
begin
  with (dm.ds_distributor.DataSet) do begin
    Filtered := False;
    dm.tab_dodavatelFilterRecord(dm.ds_distributor.DataSet,Accept);
    Filtered := True;
  end;
end;
Where is the letter 'A'?

danten 15. Aug 2012 16:20

AW: DBGrid filtering
 
I am sorry, Sorry, I forgot to change the sign:

Accept := (Length(f.AsString)>0) and (f.AsString[1] > frm_export.sEdit1.Text) and (f.AsString[1] <= frm_export.sEdit2.Text);
new
Accept := (Length(f.AsString)>0) and (f.AsString[1] >= frm_export.sEdit1.Text) and (f.AsString[1] <= frm_export.sEdit2.Text);
is work.
Thanks all.


Alle Zeitangaben in WEZ +1. Es ist jetzt 17:42 Uhr.
Seite 2 von 2     12   

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
LinkBacks Enabled by vBSEO © 2011, Crawlability, Inc.
Delphi-PRAXiS (c) 2002 - 2023 by Daniel R. Wolf, 2024-2025 by Thomas Breitkreuz