RE: Re: RE: Re: RE: Code parameters tool tip shortcut doesn't work in Toad 11.0.0.116

> Quoting my original post: In Toad Options I have "Enable parameter assistance" turned on (and Use inline assistance turned off). :)

Sorry, I missed that. Besides the obvious bug regarding shortcut key activation, what do you not like about it under those option settings? Are you noticing differences in functionality? Using those options it should be functionally equivalent to the old, if it is not then I may need to tweak some things.

> it involved in some memory error or access violation error that toad popped up and then the tab got stuck.

Now we get to the real problem. AVs and other unexpected exceptions will cause unpredictable behavior. When you receive those errors please post here with your Toad.elf file. In most cases that file contains the log data for unhandled exceptions which helps us track down and resolve issues. Having a "force close (or cancel)" option for a session or query execution is not really the solution if the trigger is an AV that can be resolved. You will certainly encounter more issues down the road even if Toad can allow you to forcibly kill a session or close a tab.

> The next time it happens i'll try to attach some screenshots.

This won't be necessary. The ELF file or a reproducible scenario are the two things that will help the most. Feel free to send your ELF file to the list or to me privately and I'll take a peek. If you've experienced this issue in recent weeks then the ELF file should contain valuable data.

Michael

From: [email protected] [mailto:[email protected]] On Behalf Of morl_937
Sent: Monday, November 28, 2011 10:41 AM
To: [email protected]
Subject: [toad] Re: RE: Re: RE: Code parameters tool tip shortcut doesn't work in Toad 11.0.0.116





Message from: morl_937


>"Check out... View|Options|Editor|Code Assist. Uncheck "Use inline assistance"" Quoting my original post: In Toad Options I have "Enable parameter assistance" turned on (and Use inline assistance turned off). :) >"I believe in the spring. We just started the cycle." Too bad. This was really a handy shortcut :( >"What kind of statements are you executing when you see this behavior? If it's truly finished then we should get an end execution notification from the DB and Toad should update accordingly. It sounds like we are not in your case. If you have a reproducible case, run SQL Tracker (in same path as Toad.exe) and monitor Toad. Reproduce your scenario and see if there is a query that is hanging. It's possible that your Toad options require some post-execution queries to be run that may be problematic." I can't reproduce really, since the statements that cause this vary. If I remember correctly it involved in some memory error or access violation error that toad popped up and then the tab got stuck. Other tabs in the same editor were still working, only the specific tab didn't respond. I've encountered it about a dozen times already. This happened also in 10.6.1, so it's not something that was introduced only in this new release. >"In the past it has been brought up many times that query cancellation can be slow. We send a cancel request and await the DB's response. As far as I know the delay is due to the DB or the client DLL taking a long time to process the request, but my knowledge of the OCI and DB in this area is pretty shallow so that's just a guess." I don't think it's actually trying to cancel the query execution or do anything related to the DB. My guess that it's something more generic than that. If I remember correctly - the statements did finish on the DB side on all occasions- it's not like I had a long running query that i'm trying to stop... The next time it happens i'll try to attach some screenshots. -Mor

_______________________________________

Historical Messages


Author: morl_937
Date: Mon Nov 28 07:40:50 PST 2011
>"Check out... View|Options|Editor|Code Assist. Uncheck "Use inline assistance"" Quoting my original post: In Toad Options I have "Enable parameter assistance" turned on (and Use inline assistance turned off). :) >"I believe in the spring. We just started the cycle." Too bad. This was really a handy shortcut :( >"What kind of statements are you executing when you see this behavior? If it's truly finished then we should get an end execution notification from the DB and Toad should update accordingly. It sounds like we are not in your case. If you have a reproducible case, run SQL Tracker (in same path as Toad.exe) and monitor Toad. Reproduce your scenario and see if there is a query that is hanging. It's possible that your Toad options require some post-execution queries to be run that may be problematic." I can't reproduce really, since the statements that cause this vary. If I remember correctly it involved in some memory error or access violation error that toad popped up and then the tab got stuck. Other tabs in the same editor were still working, only the specific tab didn't respond. I've encountered it about a dozen times already. This happened also in 10.6.1, so it's not something that was introduced only in this new release. >"In the past it has been brought up many times that query cancellation can be slow. We send a cancel request and await the DB's response. As far as I know the delay is due to the DB or the client DLL taking a long time to process the request, but my knowledge of the OCI and DB in this area is pretty shallow so that's just a guess." I don't think it's actually trying to cancel the query execution or do anything related to the DB. My guess that it's something more generic than that. If I remember correctly - the statements did finish on the DB side on all occasions- it's not like I had a long running query that i'm trying to stop... The next time it happens i'll try to attach some screenshots. -Mor
__

Author: Michael Staszewski
Date: Mon Nov 28 07:00:16 PST 2011
> I really don't like the new param assistance Check out... View|Options|Editor|Code Assist. Uncheck "Use inline assistance" > When is 11.1 going to be released? I believe in the spring. We just started the cycle. > tabs stuck in "executing" even though the db session finished it's work. What kind of statements are you executing when you see this behavior? If it's truly finished then we should get an end execution notification from the DB and Toad should update accordingly. It sounds like we are not in your case. If you have a reproducible case, run SQL Tracker (in same path as Toad.exe) and monitor Toad. Reproduce your scenario and see if there is a query that is hanging. It's possible that your Toad options require some post-execution queries to be run that may be problematic. > Pressing "stop execution" or trying to close the connection do no good. In the past it has been brought up many times that query cancellation can be slow. We send a cancel request and await the DB's response. As far as I know the delay is due to the DB or the client DLL taking a long time to process the request, but my knowledge of the OCI and DB in this area is pretty shallow so that's just a guess. Michael
__

Author: morl_937
Date: Mon Nov 28 07:00:16 PST 2011
Thanks for acknowledging this as a bug. I really don't like the new param assistance - the old tooltip was just fine, but hey, that's just me. When is 11.1 going to be released? btw, there's also a very annoying bug of tabs stuck in "executing" even though the db session finished it's work. Pressing "stop execution" or trying to close the connection do no good. It won't even let close Toad normally. the only way out is to kill the process. Are you familiar with this bug? you can see other people complaining about it here: http://toadfororacle.com/thread.jspa?threadID=30082&tstart=0.
__

Author: Michael Staszewski
Date: Mon Nov 28 06:16:41 PST 2011
This is a bug. The param assistance popup underwent some major changes for Toad 11 and the shortcut to show it was non-functional. I had it "fixed" prior to release, but there were too many outstanding issues with it to keep it in place. It's on my TODO list for 11.1. Michael
__

Author: morl_937
Date: Mon Nov 28 00:53:08 PST 2011
Hi, In Toad Options I have "Enable parameter assistance" turned on (and Use inline assistance turned off). Whenever I write a procedure/package method/function name and then "(" I get the parameter list, but once it disappears pressing the Code parameters tool tip shortcut (CTRL+SHIFT+SPACE) doesn't do anything. The only way to get the parameters again is to delete the "(" and write it back again. I also tried to change the shortcut combination under Editor-->Behavior-->Key mapping...-->Code parameters tool tip, but it did not change anything. In version 10.6.1 it worked like a charm. Please help! Thanks.
__
_______________________________________