Cancaling a long running query
Posted: Wed 09 Nov 2011 12:56
Does ODAC allows cancaling/aborting of a long running select statement made by TOraQuery?
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.