Devart Forums

First, the latest release is great!

But there is a small bug with FilterSQL:

i have a bool column, so till today my filter string in zeos was
"NOT myboolfield" (SELECT ... WHERE not myboolfield).

PostgresDAC Raises an exception "illegal filter expression".

if i change the statement to

"myboolfield=FALSE" (SELECT ... WHERE myboolfield=FALSE)

everything works fine.

Daniel

Maybe you have used the Filter property instead of FilterSQL. The Filter property is parsed localy and does not support such expressions.

The FilterSQL property is added to the value of the SQL property. So it supports any expression that PostgreSQL server supports.