da-soft - Data Access Technologies

Additional

dbCAP

AnyDAC

ThinDAC

NCOCI8

Topic: Interrupt SQL Query excecution in Oracle

Forum List » AnyDAC » v 1.x General English

christian
User

Junior Boarder

Posts: 11

Karma: 0

Interrupt SQL Query excecution in Oracle

Posted: 2008/03/27 10:54

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

Diman

Admin

Posts: 1461

Karma: 18

Re:Interrupt SQL Query excecution in Oracle

Posted: 2008/03/27 23:57

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

christian
User

Junior Boarder

Posts: 11

Karma: 0

Re:Interrupt SQL Query excecution in Oracle

Posted: 2008/03/31 04:54

thank you Dmitry

best regards,

Christian Balz

Forum List » AnyDAC » v 1.x General English