very small bug with FilterSQL

Discussion of open issues, suggestions and bugs regarding PgDAC (PostgreSQL Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Posts: 73
Joined: Thu 05 Feb 2009 15:29
Location: Dresden

very small bug with FilterSQL

Post by dschuch » Tue 13 Oct 2009 06:58

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.


Devart Team
Posts: 2844
Joined: Wed 10 May 2006 07:09

Post by Plash » Tue 13 Oct 2009 08:20

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.

Post Reply