iifedy / aseisql

Automatically exported from code.google.com/p/aseisql
0 stars 0 forks source link

Cannot cancel the query when its running. #23

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago
What steps will reproduce the problem?
1.Create a stored procedure with cursor call 2nd proc inside the first 
proc.
2. execute the query with parameters
3. cancel the execution and cancel wont work. 

What is the expected output? What do you see instead?
Query cancelled.

What version of the product are you using? On what operating system?
XP: latest.

Please provide any additional information below.

Original issue reported on code.google.com by bhushanv...@gmail.com on 11 Aug 2009 at 9:15

GoogleCodeExporter commented 8 years ago
That's right. 
Right now the cancel notification sent to server only on row incoming message.
So if your procedure does not return rows? cancel will not work.
--
For development: I think it's possible to correct this "feature" in syb_exec.dll
Probably it's not necessary to wait for a row to return cancel notification,
but to call ct_cancel(connection, cmd, type) method of ctlib...

Original comment by daggett....@gmail.com on 12 Aug 2009 at 7:45

GoogleCodeExporter commented 8 years ago
fixed in revision #119

Original comment by daggett....@gmail.com on 17 Aug 2009 at 6:33