Devart Forums

Posted: **Mon 18 May 2009 19:57**

Should a filter expression on TPgQuery using 'IN' cause an exception?

I have the following code

PgQuery.Filter := 'id IN(8,10,22)';
PgQuery.Filtered := True; // Illegal filter expression

It raises an Illegal filter expression. Why?

Posted: **Tue 19 May 2009 06:58**

Filter does not support IN expression.

Posted: **Tue 19 May 2009 18:31**

So is it then recommended to build and OR list of all values for the field I wish to filter on?

Posted: **Wed 20 May 2009 07:10**

Yes, you can use OR operator to build an expression.

Posted: **Wed 20 May 2009 11:20**

Yes, you can use OR operator to build an expression.

Yes this is what I ended up implementing.

Thanks

Filter expression using 'IN'