Thomas,
I'm just thinking that if using EXISTS when returning 100000+ records is a
showstopper, then someone (e.g. Dmitry) ought to be made aware of it even
though you got around it using JOIN. Anything peculiar beyond using exists?
I just asked IB_SQL to return me 226000 records using one exists - which it
did without any problems.

Set

At 13:45 09.11.2002 +0100, you wrote:

>I have the issue below now solved with using a JOIN instead
>of EXISTS. This works for me now (don't ask me why), and I
>can fetch any number of records from the client application.
>Just to let you all know ;-).