Is there a way to cancel query execution?

zd · Post by zd » 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!

Plash · Post by **Plash** » 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.

zd · Post by zd » Tue 16 Sep 2008 16:28

Thank you for the answer!