Cancel long query on TOracleDataset

[rakgol_a]

Hi,

Is there a way to cancel a long query with
some kind of a callback function. Some
examples will be highly appreciated.

I'm using DOA3.3.x with CBuilder5 SP1 on 2000 SP2.

Thanx in advance.
Alfred

 

[Marco Kalter]

To stop the fetch processing, you can perhaps use the TOracleDataSet.AfterFetchRecord event. The documentation contains an example.

To cancel query execution processing (which can take a long time due to internal sorts or aggregation functions), you would have to open the dataset in a background thread and call TOracleSession.BreakExecution to cancel the operation.

------------------
Marco Kalter
Allround Automations