No wonder - if you are trying to return a result set greater than 10 million rows. You would see the same problems with sql server or oracle.

My advice to you is to develop a batch process that aggregates your data into something more manageable.

< JVP >


>hi cetin
>i'm doing it this way because the data is clipper and on an advantage database server (ps. C:\TEMP\ was just an example). it's the only way i can access the live data without getting errors (see:821289).
>this whole thing's proving to be trickier than i first thought.
>kind regards,
>barry