> > Are you using the SQL trace monitor? What is the FetchWholeRows property

set

> > too? have you tried the query using a TIB_Cursor?
> >
> What is the SQL trace monitor ?

The most important tool for solving problems such as this...

It gives you a look at exactly what is being sent to the server. Drop down a
TIB_MonitorDialog component and call its Show method.

> FetchWholeRows doesn't help.

It might not help you but it would help me if you would tell me what you
have it set to. It will be best if you set it to true.

> With a TIB_Cursor all works fine, only IB_Query makes these problems.

As I suspected.

You must not be using the JoinLink property correctly.

Have you considered using the FROM ... JOIN ... declarative syntax?

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