Filter expression using 'IN'

yozey · Post by **yozey** » 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?

Plash · Post by **Plash** » Tue 19 May 2009 06:58

Filter does not support IN expression.

yozey · Post by **yozey** » 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?

Plash · Post by **Plash** » Wed 20 May 2009 07:10

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

yozey · Post by **yozey** » 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