Unable to close SQLConnection while SQLQuery is active

Discussion of open issues, suggestions and bugs regarding usage of dbExpress drivers for Oracle in Delphi and C++Builder
Post Reply
amota
Posts: 1
Joined: Mon 24 Aug 2009 09:58

Unable to close SQLConnection while SQLQuery is active

Post by amota » Mon 24 Aug 2009 11:03

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?
Top
Plash
Devart Team
Posts: 2844
Joined: Wed 10 May 2006 07:09

Post by Plash » Tue 25 Aug 2009 08:51

dbExpress components have no method to stop execution of a query.

You can try to kill the thread using the TerminateThread function.
Top
Post Reply

Return to “dbExpress driver for Oracle”