Devart Forums

Is is possible to cancel an executing query, like Query Analyzer does? Thanks.


Ray Mond

Please see TCustomMSDataSet.BreakExec description

How do I go about using this method? Do I create one TMSConnection, but 2 different TMSQuery components in 2 different threads, both connected to the same TMSConnection, where one runs the query and the other cancels it whenever needed?

Ray Mond

Not, you must use at the single thread own TMSConnection and TMSQuery. If necessary, break an execution, from another thread call BreakExec of TMSQuery. It is a seldom case when with the single component (TMSQuery) can work from several threads at the same time.

So it works like this?

I have a GUI app. To run a query, I create a thread with it's own TMSConnection and TMSQuery. When I want to cancel the query, I call the TMSQuery's BreakExec from my main form?

Ray Mond

Yes, you are absolutely right

Assuming that I can cancel executing query from main thread with BerakExec. This mean I must run query in separate thread. But now I want to have both possibilities: to cancel query, running in the separate thread and to display recordset in a grid in main thread.

The question is: how can I put recordset in main thread?

With ADO I can handle it just assigning MainThreadADODataSet.Recordset = InterruptableThreadADODataSet.Recordset;
on thread terminate.
But with SDAC I have no idea.

SDAC doesn't support such functionality.