0

Singular filter on some column works, for example:

SQLQuery.Filter := 'ColumnName="some_filtered_text"'; // OK

But how to apply filter to many columns?

For example this doesn't work:

SQLQuery.Filter := 'ColumnName1="some_filtered_text1",
    ColumnName2="some_filtered_text2"'; // Exception

It raises exception: "TApplication.HandleException Operator/function missing".

TSr
  • 331
  • 1
  • 12
  • 1
    It is like SQL `where` condition. Use `and` instead of comma: `ColumnName1="some_filtered_text1" and ColumnName2="some_filtered_text2"` – Abelisto Jan 28 '16 at 10:52
  • @Abelisto: this solves my problem. Thanks! It's so easy... – TSr Jan 28 '16 at 12:12

0 Answers0