This is not an acceptable Borland Database Engine filter syntax. This is
primarily what IBO's filter is designed to emulate. In the past I let SQL go
through in some cases but that wasn't fully handling things as it should. No
need to go into the details.

Anyway, I now parse all filter statements to apply the filter options and
wildcards. If you want the former behavior to ignore and pass through the
filter as SQL then you need to preface the filter text with this signature:

::SQL::

Ideally what you should be using is the SQLWhereItems( ) in the OnPrepareSQL
event. This allows you to easily augment the SQL statement sent to the
server at the time the statement is prepared. See also the InvalidateSQL
method as it comes in handy with the Refresh method.

HTH,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: "Marcilio Soares" <marcilio.soares@...>
To: <IBObjects@egroups.com>
Sent: Tuesday, January 23, 2001 2:46 PM
Subject: [IBO] Filter in IB_Query


> I setting property Filter to
> PRODID IN (SELECT PRODID FROM FORNEC) to IBTable,
> but in IB_Query(Filter)
> i see ISC_Error_Code "Token unknown -line6,char 15... IN)
> How to make property Filter in IB_query with IBO 3.6Ca?
>
>
>
>