Subject [IBO] Quickly killing a TIB_query
Author Paul Hope
Hi

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?

Regards
Paul


[Non-text portions of this message have been removed]