I beieve my problem is that I do not have an index for the query.

--- In IBObjects@y..., "wcgage" <wcgage@y...> wrote:
> 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?