TMSQuery hang on when you call close method

[matriks]

Hello,

I want to make a very simple data viewer to execute sql statements like MS SQL Managment Studio Query Window.
To do this, I but two buttons on a form; one of them is to execute the stored procedure the other one is to cancel the query at any time by calling BreakExec command. I set the TMSQuery's NonBlocking property option to True. Everything works so far. The problem is occurs when i call the TMSQuery close method. It's waiting to catch rest of the rows. As you know, MS SQL Managment Query Window has this ability. You can execute a stored procedure witch is included huge dataset you can stop and close Query Window at any time you want without waiting to get residues. How can i do the same thing? How can i close TMSQuery without waiting to catch other records?

Waiting for your help,
Yours Sincerely

[azyk]

Hello,

This behaviour is due to the specificity of the OLEDB provider, it hangs on freeing resultset. We can't influence this behaviour.