Subject RE: [IBO] Re: Filters
Author Departamento de Desarrollo

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

-----Original Message-----
From: wcgage [mailto:wcgage@...]
Sent: Thursday, July 11, 2002 6:15 PM
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
> 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.
___________________________________________________________________________ - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !

Your use of Yahoo! Groups is subject to