DBGrid filtering

[danten]

Hi friends,
I need the DBGrid display only records from the "A" to "D".

Thanks

[himitsu]

TDataSet.Filter + TDataSet.Filtered

Oder bei "besseren" Komponenten ala DevExpress, da gibt es auch noch eine zusätzliche Filterung im Grid/DataControler, welche man nutzen könnte.

[danten]

Zitat von himitsu:

TDataSet.Filter + TDataSet.Filtered

Oder bei "besseren" Komponenten ala DevExpress, da gibt es auch noch eine zusätzliche Filterung im Grid/DataControler, welche man nutzen könnte.

OK,here is a possibility of something like Uppercase and Lowercase, as well as the ability to input QuotedStr array [a..d]?

Delphi-Quellcode:

with dm.ds_distributor.DataSet do begin
    Filtered := False;
    Filter := 'Firma = ' + QuotedStr(Uppercase('A')) + ' OR ' +
  'Firma = ' + QuotedStr(Uppercase('D')) + ' OR ' +
  'Firma = ' + QuotedStr(Lowercase('A')) + ' OR ' +
  'Firma = ' + QuotedStr(Lowercase('D'));
    Filtered := True;
end;;

Thanks

[DeddyH]

Alternatively you could use a Query-Component with a SQL-Statement like this:

SQL-Code:

SELECT
  <Fieldlist>
FROM
  <your table>
WHERE
  UPPER(Firma) IN ('A', 'B', 'C', 'D')

[Bummi]

I'd prefer SQL, but perhaps you would prefer the Event OnFilterRecord

[danten]

Zitat von Bummi:

I'd prefer SQL, but perhaps you would prefer the Event OnFilterRecord

SQL:

Delphi-Quellcode:

SELECT *
FROM distributor
WHERE Firma >='A' AND Firma <'D'

I am interested in the possibility onFilterRecord.

[Furtbichler]

Then RTFM and find out. It seems as if you always want us to do the work.
Implementing an OnFilterRecord-Event is as simple as posting a question here.

Go on!

[mkinzler]

Zitat:

Implementing an OnFilterRecord-Event is as simple as posting a question here.

If you know about basics. But that seems a great donot these days.

[Furtbichler]

Hmmm.
Entering the Eventname plus 'example' in Google and press 'search'? Easy.
Read the examples? Easy.
Open Delphi and load the project? Easy.
Find the event in the objectinspector? Easy.
Doubleclick? Easy.
Adapt the example found in google? ...

[danten]

Zitat von Furtbichler:

Hmmm.
Entering the Eventname plus 'example' in Google and press 'search'? Easy.
Read the examples? Easy.
Open Delphi and load the project? Easy.
Find the event in the objectinspector? Easy.
Doubleclick? Easy.
Adapt the example found in google? ...

Write an example here is easy, but for you a problem.

Delphi-Quellcode:

 with dm.ds_distributor.DataSet do begin
    Filtered := False;
    Filter := 'Firma <> ' + QuotedStr('A') + ' AND ' +
  'Firma <= ' + QuotedStr('D');
    Filtered := True;
end;

That's what I needed without google ....