Well, it may be impossible to abort the query while the server is
generating the result, but it is at least possible to abort fetching all
records to the client. I haven't checked how it is done, but IB_SQL
(developed by IBObjects) gets an Abort button after fetching the first few
records if this fetching takes some time.

Set

At 11:01 19.03.2003 +0100, you wrote:

> > This tables contains almost 1.000.000 records.
> >
> > Every once in a while my customer(s) does a report that end up
> > selecting almost every record.
> > Then when my program opens this query it takes quite some time.
> >
> > Is there no way to abort this ?
> >
> > I use D5 Ent and INterbaseExpress comp from borland and FB1.0.
>
>If you're using the Classic architecture on Linux, you, theoratically,
>can kill the process for that client. But for the rest, no - there's no
>decent way to abort a query.