newbie question

snorkel · Post by **snorkel** » Tue 08 Aug 2006 15:12

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

swierzbicki · Post by **swierzbicki** » Tue 08 Aug 2006 15:27

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

Jackson · Post by **Jackson** » Wed 09 Aug 2006 09:05

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.