Cancaling a long running query

Discussion of open issues, suggestions and bugs regarding ODAC (Oracle Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
lior
Posts: 36
Joined: Mon 01 Aug 2011 07:11

Cancaling a long running query

Post by lior » Wed 09 Nov 2011 12:56

Does ODAC allows cancaling/aborting of a long running select statement made by TOraQuery?

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Post by AlexP » Thu 10 Nov 2011 08:43

Hello,

To terminate execution of the operation you should set the TOraQuery.NonBlocking property to true and execution process will run in a separate thread, and you will be able to terminate the process with the help of the OraQuery1.BreakExec method. You can find more detailed information in the ODAC help, TCustomDADataSet.BreakExec Method section.

Post Reply