Interrupt Oracledataset query

[Betz]

Hello,

I have a problem with Oracledatasets, where I cannot find an easy solution. Possibly somebody can help me.
I have created an application with Delphi7 that shows Data out of Oracle by using Oracledataset.
The query is entered by QBE.
When such an QBE is executed, I found no easy solution to interrupt a looooong running query.
Has somebody a solution how to interrupt such a query. Is there an easy way to do the query in multithreading, so that I can try to interrupt the query by clicking e.g. a button.

Thanks

 

[Marco Kalter]

You can download a little project that demonstrates a cancelable dataset here:

http://www.allroundautomations.com/download/canceldataset.zip

It uses a background thread to open the dataset, so that it can be cancelled from the main thread. During the fetching phase, it is cancelled by using the AfterFetchRecord event.

 

[Betz]

Dear Marco,
Thanks a lot for the fast reply.

I have tested your demo and it seems to be exactly what I need.

Thanks

Uli