Page 1 of 1

Unable to close SQLConnection while SQLQuery is active

Posted: Mon 24 Aug 2009 11:03
by amota
In a multi-threaded environment I have a SQLQuery that sometimes takes too long to execute completely.
I cant find a way to close neither the SQLQuery nor the associated SQLConnection. The SQLConnection "close" method seems to wait until the SQLQuery is done completely.
Is there a way to do this? I mean, to kill the execution of the SQLQuery and close the associated SQLConnection?

Posted: Tue 25 Aug 2009 08:51
by Plash
dbExpress components have no method to stop execution of a query.

You can try to kill the thread using the TerminateThread function.