Devart Forums

Hi,
Just wondering if it is possible to cancel a long running query?

I see that the query component has a cancel method, but not sure it that is what it is for.

Thanks,

Snorkel

That is not possible , if I remember this is a server side feature that mysql doesn't have

You can create additional connection and execute 'KILL :ThreadID' from it.
Use TMyConnection.ThreadId property to fill ThreadID parameter value.
TDataSet.Cancel method cancels modifications to the active record if those changes are not yet posted, and TDataSet.Cancel is not related to breaking execution.