RE: TOAD doesn't like FOR statement?

I guess the apple didn't fall far from the tree in the smarts department.  We're both learning and hopefully we'll get some of the rules promoted into the 6th grade during the beta cycle.

Greg - squiggle (feeling really) dumb

From: [email protected] [mailto:[email protected]] On Behalf Of Michael Moore
Sent: Monday, October 10, 2011 04:30 PM
To: [email protected]
Subject: Re: [toad] TOAD doesn't like FOR statement?



I had to turn it off. It became too annoying especially during the development phase when things are generally a mess. When I'm all done coding, I use  Code Analyzer. Also, many of the rules are problematic. For example:

      c_aff_key_username_nomatch     CONSTANT PLS_INTEGER := -20013;
      aff_key_username_nomatch                EXCEPTION;
      PRAGMA EXCEPTION_INIT (aff_key_username_nomatch, -20013);

It tells me that aff_key_username_nomatch is not referenced when it is referenced in the very next line.

Still, it DOES catch problems, so I do use it while wishing it was smarter. :-)

Mike

On Mon, Oct 10, 2011 at 1:18 PM, Gregory Liss <[email protected]<mailto:[email protected]>> wrote:

We don't have a "ignore this rule" or "ignore this instance" feature yet...yet.   That sounds like a good one for the Idea Pond!

From: [email protected]<mailto:[email protected]> [mailto:[email protected]<mailto:[email protected]>] On Behalf Of Wendy Penfold
Sent: Monday, October 10, 2011 03:59 PM
To: [email protected]<mailto:[email protected]>
Subject: Re: [toad] TOAD doesn't like FOR statement?

Cool...I'm not getting the mouse over, but I can right click and see the rule violation.  Is there anyway I can get the blue squiggles to turn off once I've reviewed it without turning the feature off entirely?

On 10/10/2011 3:35 PM, Gregory Liss wrote:

It's not that it doesn't like it.  Well it kind of doesn't like it.  That's the new Code Analysis feature.  If you mouse over the blue squiggles, it'll show you what rule has been violated.  Also, if you right click on the blue squiggles, you'll see a menu item or Rule Violations and you can get a detailed explanation of what it doesn't like.  The blue squiggles don't affect the ability to compile but do show you some possible issues in the "best practices" world.

Greg
(squiggle dumb).

From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of Wendy Penfold
Sent: Monday, October 10, 2011 02:54 PM
To: ToadList
Subject: [toad] TOAD doesn't like FOR statement?

Hi, I just upgraded to 11.0.0.116 and Toad seems to not like the FOR statement in this proc...although the package compiles ok.

[cid:[email protected]]