Filters that are pure SQL and fairly complex need to be prefaced with
::SQL:: now.

Sorry about that...

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

----- Original Message -----
From: <xomp@...>
To: <IBObjects@egroups.com>
Sent: Sunday, December 17, 2000 11:06 AM
Subject: Re: [IBO] Searching within a TIB_Query using Locate?


> Hello Jason,
>
> Starting with versions Cx
>
> TIBOTable.Filter :=
> 'DEPARTMENT WHERE COMPNO = 1 AND
> DEPTNO IN (SELECT DEPTNO FROM DEPARTMENT WHERE COMPNO = 1)'
>
> or
>
> TIBOTable.Filter :=
> 'DEPARTMENT WHERE COMPNO = 1 AND
> (DEPTNO IN (SELECT DEPTNO FROM DEPARTMENT WHERE COMPNO = 1))'
>
> now fail to parse.
>
> I may have over simplified the SQL such that the question doesn't
> nake much sense anymore, but that is imaterial :)
>
> Best Regards,
> Hans
>
>
>
>