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.