Peter,

> In the end I added a new TIB_Query, put in exactly the same sql and
> deleted the old one, this works fine.

Have you had a look in the .dfm file to see if there was some other
settings applied to the Query?

Luc.