TMSQuery hang on when you call close method
Posted: Wed 23 Apr 2014 22:30
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
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