Filter Record

[danten]

Hi all,
I need to filter a large database of the selected conditions.
ComboBox1 = choice of table columns (FiledByName)
ComboBox2 = selection operator (<> =)
Edit1 = search text

I get an error in this code:

Delphi-Quellcode:

DataSource1.DataSet.Filtered := False;
  DataSource1.DataSet.Filter := QuotedStr(ComboBox1.Text)+ QuotedStr(ComboBox2.Text) + ' '+
  QuotedStr(Edit1.text);
  DataSource1.DataSet.Filtered := True;

I thank you all for your help.

[Perlsau]

Nobody can help you if you don't describe the error you got. For example it could be a type mismatch error when you try to filter a integer column by a string argument. And you will get an error when you quote the selection operator. Your selection operator is already a string.

[haentschman]

Morning...
try this.

Delphi-Quellcode:

DataSource1.DataSet.Filtered := False;
DataSource1.DataSet.Filter := ComboBox1.Text + ComboBox2.Text + ' ' + QuotedStr(Edit1.text);
DataSource1.DataSet.Filtered := True;

...only the Search Value must be quoted.