Subject | [IBO] Quickly killing a TIB_query |
---|---|
Author | Paul Hope |
Post date | 2003-09-02T11:56:21Z |
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]
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]