v 4.2G
using TIBOQuery and TIBODatabase

I have been having wierd results trying to use the Filter property
of IBObjects.

I have a simple query that is like the following

SELECT Count(*), PRODUCT_CODE, SUM(BALANCE) BAL FROM ACCOUNTS GROUP
BY PRODUCT_CODE

it runs fine

I try to set the filter to the following
COUNT > 10

I get the following error
SQL error code = -104
Token unknown - line 2, char 12

>

I even tried the above on other queries doing the same thing and
against different databases and still get the same error.

I tried changing the filter to

COUNT = 10

and I get...
SQL error code = -104
Token unknown - line 2, char 12
=

Then I have tried filtering off other fields
PRODUCT_CODE = 'L11'
this worked

I tried another field
BAL > 1000

and I get the error
SQL error code = -206
column unknown
BAL

Is there some sort of setting I need to make to get the filter to
function consistently?

Or is there a bug with the filtering in version 4.2?

Bill