try:

SELECT A.'Name', A.'Type' FROM MyTable A

-----Original Message-----
From: wcgage [mailto:wcgage@...]
Sent: Thursday, July 11, 2002 6:15 PM
To: IBObjects@yahoogroups.com
Subject: [IBO] Re: Filters


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?



___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/