Additional
AnyDAC
SimpleIAX
Forums
Welcome, Guest
Please Login or Register to post messages. Lost Password?
Interrupt SQL Query excecution in Oracle
(1 viewing) 1 Guest
Go to bottom
TOPIC: Interrupt SQL Query excecution in Oracle
#12250
christian
Fresh Boarder
Posts: 11
graphgraph
Karma: 0
User Offline Click here to see the profile of this user
Interrupt SQL Query excecution in Oracle 2008/03/27 10:54 (6 Years, 8 Months ago)
When I execute one script SQL and initiate one transaction, as I can cancel this operation, without having that to execute one rollback. Seems to the button "Break" that this in the console of the PL/SQL Developer.

With my best regards,

Christian Balz
Logged Logged
The administrator has disabled public write access.
#12251
Support
Moderator
Posts: 5855
graph
Karma: 101
User Offline Click here to see the profile of this user
Re:Interrupt SQL Query excecution in Oracle 2008/03/27 23:57 (6 Years, 8 Months ago)
Hello

To give to an end-user ability to cancel long running queries, do following:
- set TADQuery.ResourceOptions.AsyncCmdMode = amCancelDialog
- drop TADGUIxFormsAsyncExecuteDialog to your form

Run application, run query. After some timeout AnyDAC will show dialog allowing to cancel query execution.

Regards,
Dmitry
With best regards,
DA-SOFT Technologies Support Team
Logged Logged
The administrator has disabled public write access.
#12252
christian
Fresh Boarder
Posts: 11
graphgraph
Karma: 0
User Offline Click here to see the profile of this user
Re:Interrupt SQL Query excecution in Oracle 2008/03/31 04:54 (6 Years, 8 Months ago)
thank you Dmitry

best regards,

Christian Balz
Logged Logged
The administrator has disabled public write access.
Go to top