Devart Forums

Posted: **Sun 14 Sep 2008 11:37**

Hi!

After calling TIBCQuery.Open, is there a way to cancel the execution of the query? If there is no direct way, is there a workaround?

I'm making a search function in my app, and I'd like to enable my users to cancel query execution if it's taking too long.

Thank you!

Posted: **Tue 16 Sep 2008 07:59**

In Firebird 2.1 you can cancel execution of a statement by deleting a record from the MON$STATEMENTS table:

Code: Select all

delete from mon$statements where mon$sql_text = :sql_text

In other versions of InterBase/Firebird there is no way to cancel execution of a statement.

Posted: **Tue 16 Sep 2008 16:28**

Thank you for the answer!

Devart Forums

Is there a way to cancel query execution?

Is there a way to cancel query execution?