Toad World® Forums

Toad for SQL Commenting\Navigation

What I would like to do:

  1. Use the Navigator Panel to organize a series of queries in a single script.

now then I do have them decorated with -- region areas and then I am placing "go" after the region in order to have it display with the corresponding region name in the navigated. So basically I have a bunch of batches with one query each. This works fine for Level 0 to 1 depth, unfortunately if I try to do anything else it kinda falls apart as that second level in the navigator really only shows like "Batch--Select" for the type of sql statement that it contains.

Now granted I probably am pushing envelop on the poor sql navigator. But I figured if there was some sort of tags or keywords I was missing in order to designated children of a particular region,(well I was hoping it was something that simple.)

Does anyone know if this is currently possible 5.0.2 full version. If not any suggestions for how best to tackle this. I generally like to scaffold out logic in my stored procs in this manner before putting it all together.

p.s the attached image is what I am referencing in my navigation scheme.

Message from: Natalia Burochkina

Hello,
Thanks for your input. I see your problem. Now we don’t have possibility to
organize second level of region.
Will you satisfy if we realize sub-region functionality? If so, I can create
enhancement for this.
Nata


Historical Messages

Author: Natalia Burochkina
Date: Mon May 16 06:58:11 PDT 2011
Hello,
Thanks for your input. I see your problem. Now we don’t have possibility to
organize second level of region.
Will you satisfy if we realize sub-region functionality? If so, I can create
enhancement for this.
Nata

__

Author: Andrej Milas
Date: Wed Apr 27 10:38:33 PDT 2011
What I would like to do: 1. Use the Navigator Panel to organize a series of
queries in a single script. now then I do have them decorated with – region
areas and then I am placing “go” after the region in order to have it display
with the corresponding region name in the navigated. So basically I have a bunch
of batches with one query each. This works fine for Level 0 to 1 depth,
unfortunately if I try to do anything else it kinda falls apart as that second
level in the navigator really only shows like “Batch–Select” for the type of
sql statement that it contains. Now granted I probably am pushing envelop on the
poor sql navigator. But I figured if there was some sort of tags or keywords I
was missing in order to designated children of a particular region,(well I was
hoping it was something that simple.) Does anyone know if this is currently
possible 5.0.2 full version. If not any suggestions for how best to tackle this.
I generally like to scaffold out logic in my stored procs in this manner before
putting it all together. p.s the attached image is what I am referencing in my
navigation scheme.
__


Hello,
Thanks for your input. I see your problem. Now we don’t have possibility to organize second level of region.
Will you satisfy if we realize sub-region functionality? If so, I can create enhancement for this.
Nata