> I have a simple form with a TIB_Query and a grid.
> The query selects from a stored procedure which takes some time per row.
> When the form is created the query opens and the first lot of data is

displayed.

>
> When I close the form I have to wait about 1 minute with the SQL cursor

displayed before the form goes.

>
> In OnClose I have tried query.AbortFetching, query.Close,
> query.IB_Transaction.Rollback to no effect. How do I get it to close

quickly?


You would have to use the async cancel query that is in the later versions
of InterBase. To my knowledge there isn't such an option with Firebird yet.

Otherwise, waiting for the server to come back is all you can do.

Jason Wharton