No, SQLWhere simply expects SQL so there is no need.

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

----- Original Message -----
From: <xomp@...>
To: <IBObjects@egroups.com>
Sent: Monday, December 18, 2000 8:59 AM
Subject: Re: [IBO] Searching within a TIB_Query using Locate?


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