Toad World® Forums

simple question re data grid columns

In V9 (I think) you could grab the column header in the data grid and drag it
downward to where the data is showing and drop it. This would cause the entire
column to disappear (be hidden). In V10 it does not seem to work this way. You
drop the column header and nothing happens.

Is there a parameter that can restore the old functionality or is there a way I
can drop column in the data grid without leaving the data grid window?

Thanks,
Mike

Did you try above or up instead of below or down ???

Hey Mike,

In V9 (I think) you could grab the column header in the data grid and drag
it downward to where the data is showing and drop it. This would cause the
entire column to disappear (be hidden). In V10 it does not seem to work this
way. You drop the column header and nothing happens.

Is there a parameter that can restore the old functionality or is there a
way I can drop column in the data grid without leaving the data grid window?

Do you mean the little icon in the header bar all the way to the left of the
first column? It looks like a paragraph thingy and it’ll allow you to
select which columns are visible.

Rich – [TeamT]

Disclaimer: Schoooooooooooool’s out for summer!

Thanks guys, First off, I’m disgustingly lazy.

I could use the “show/hide” columns as Rich suggested but here is my typical
thought process.
I want to examine a table which say has 20-30 columns. Some of the columns will
contain meaningful data but lots of the columns will be full of legacy crap. The
problem is, I don’t know the crap columns until I am actually looking at the
data. So,
I do a SELECT * FROM MYTABLE
and start to examine the data in the data grid. Obviously, with say 25 columns,
many of them will be off the right hand side of the screen and I will have to
grab the left/right scroll bar.As I scroll to the right, my eyes are on the data
in the center of the screen. Now say I see a column with crap data. In order to
use the “show/hide” drop-down I have to move my eyes away from the column I am
currently examining and and find the little show/hide icon on the left. Then I
need to move my mouse cursor over and hit that very tiny icon. Then I need to
find the name of column (many columns are very close spellings, so I might need
to dart my eyes back and see if I got the spelling right), then I need to click
the little box next to the column I want to remove. Then Mouse back over to the
scroll bar etc etc, and repeat this process as I encounter columns I want to
remove.

The old way, move cursor up, grab the column name and drop it anywhere on the
data grid. Eyes stay focused in same location and mouse cursor does minimal
movement and I don’t even need to read the column name.

Bert, yes, tried ABOVE, being careful not to drop the column name into the
‘group by’ section. Same result, after drop, column is still there.

Regards,
Mike

On Thu, Jun 2, 2011 at 9:59 AM, Bert Scalzo wrote:

Did you try above or up instead of below or down ???

Aha – my bad – I thought you meant you wanted the group by –
sorry to steer ya wrong J

In V10 it does not seem to work this way

I see this in 10.5 and 10.6, but not in Toad 11 beta. Unless there’s an option
controlling it that I’m not seeing, this is fixed.

So Michael, you are saying you see ‘the problem’ in 10.5 and 10.6, but
it appears to be working correctly in 11?
I’m running 10.6.

Glad to hear it works in 11 beta. It’s a feature I like.

Regards,
Mike

On Thu, Jun 2, 2011 at 10:44 AM, Michael Staszewski <
michael.staszewski@quest.com > wrote:

> In V10 it does not seem to work this way

 

I see this in 10.5 and 10.6, but not in Toad 11 beta. Unless there's an
option controlling it that I'm not seeing, this is fixed.

you are saying you see ‘the problem’ in 10.5 and 10.6, but it appears to be
working correctly in 11?

Exactly.

It’s not an option. I added it to the beta.

cool, okay, thanks John.

On Thu, Jun 2, 2011 at 11:34 AM, John Dorlon wrote:

It’s not an option.  I added it to the beta.

Pure awesomeness.

in sauce form.