OK, I will do so. Can you briefly explain to me, why I should not put join
criteria in the where clause ?

Guido.

Jason Wharton wrote:

> Yes, this solves the problem. This is the one limitation that I impose on
> people to have all of the benefits that IBO offers is to:
>
> DON'T PUT JOIN CRITERIA IN THE WHERE CLAUSE, EVER.
>
> Either use the JoinLinks property or use the FROM ... JOIN ... declarative
> syntax for JOINs.
>
> Regards,
> Jason Wharton
> CPS - Mesa AZ
> http://www.ibobjects.com
>
> ----- Original Message -----
> From: <guido.klapperich@...>
> To: <IBObjects@egroups.com>
> Sent: Tuesday, January 02, 2001 1:24 PM
> Subject: Re: [IBO] IB_Query phenomenom
>
> >
> >
> > Jason Wharton wrote:
> >
> > > Use JoinLinks and never put join criteria directly in the WHERE clause.
> > >
> >
> > Is this the solution of the problem ? Because I built this query dynamicly
> and
> > when finished, I only do Query.SQL.Add(MyQuery). Using JoinLinks, it will
> be
> > more difficult, but when it solves the problem, I will do so.
> >
> > Guido.