Thank you Jason,

Does the same apply to SQLWhere ? and maybe other places ?

Best regards,
Hans

==================================



Jason Wharton wrote:

>
> 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
> >
> >
> >
> >
>