I am using an IBOQuery
I have a simple sql statement
SELECT Name, Type FROM MyTable

I set the filter to be
TYPE=1

I set the dataset to be filtered.
I run the query.

I get the error
SQL Error -206
Column unknown
TYPE

I tried changing the column name same error.
I tried using a different column same error.

Does the filter property of the IBOQuery not work?