At 09:24 PM 02-01-01 +0100, you wrote:

>Jason Wharton wrote:
>
> > Use JoinLinks and never put join criteria directly in the WHERE clause.
> >

I think Jason should have said:

EITHER use JoinLinks OR never put join criteria directly in the WHERE clause.
(If you use the more stable explicit join syntax for your statement, you
don't need JoinLinks.)

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

Repeating, if you use explicit JOINs, you won't need JoinLinks, so consider
that when building up your MyQuery string...

Helen

>Guido.
>
>

All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________