Toad World® Forums

FW: RE: enhancment request: column names in grids - modify


#1

Please pardon the Johnnie-come-lately jumping on the bandwagon.

Not all of our databases adhere closely to the standard Erwin mentions. A nice
variation on this enhancement would be the ability to ask Toad to hide the first
n characters, if they’re the same as the table name. It would be
especially handy if this hiding were to be available in code insight/completion
pick lists (e.g. the pick list that appears when one is assembling a query and
types the table name followed by a period.)

Thanks much,

Dan

Daniel B Madvig
Computer Technologies

Northwestern College & Northwestern Media
3003 Snelling Ave.
St. Paul, MN 55113
www.nwc.edu

651.631.5323

image001.jpeg


#2

The Code Insight list can already assist you if you have a table prefix. Instead
of hiding necessary and important characters of the table name, you can hit the
TAB key and any common characters are inserted into the grid. So, if your list
has 10 tables that all start with “PRE_” pressing TAB will insert
“PRE_” into the editor. This was Erwin’s request from way back
when and I personally like it because it doesn’t hide necessary characters
of the table name and works with any number of characters that form a prefix.

Michael
image001.jpeg


#3

The Code Insight list can already assist you if you have a table prefix. Instead
of hiding necessary and important characters of the table name, you can hit the
TAB key and any common characters are inserted into the grid. So, if your list
has 10 tables that all start with “PRE_” pressing TAB will insert
“PRE_” into the editor. This was Erwin’s request from way back
when and I personally like it because it doesn’t hide necessary characters
of the table name and works with any number of characters that form a prefix.

Michael
image001.jpeg


#4

Yes, that’s exactly how it works. You can hide the first n characters.
You decide what N is.

At this point, it’s just the schema browser.

Hm …and I just realized that I read his request wrong. I didn’t
do this for column names. I did it for table names. Like for the cases
when your tables all start with TBL_.
image001.jpeg


#5

Yes, that’s exactly how it works. You can hide the first n characters.
You decide what N is.

At this point, it’s just the schema browser.

Hm …and I just realized that I read his request wrong. I didn’t
do this for column names. I did it for table names. Like for the cases
when your tables all start with TBL_.
image001.jpeg


#6

I hadn’t thought of that, but yes I would like that. I might go further
and have several right click choices
image001.jpeg


#7

I hadn’t thought of that, but yes I would like that. I might go further
and have several right click choices
image001.jpeg


#8

Yet again, ask and ye have already received it. J

Perhaps that’s not in my 9.7 Toad. When I have a pick list showing and I
touch TAB, I get the highlighted column. Got to convince the powers that I need
an upgrade.

Dan

Daniel B Madvig
Computer Technologies

Northwestern College & Northwestern Media
3003 Snelling Ave.
St. Paul, MN 55113
www.nwc.edu

651.631.5323
image001.jpeg


#9

Yet again, ask and ye have already received it. J

Perhaps that’s not in my 9.7 Toad. When I have a pick list showing and I
touch TAB, I get the highlighted column. Got to convince the powers that I need
an upgrade.

Dan

Daniel B Madvig
Computer Technologies

Northwestern College & Northwestern Media
3003 Snelling Ave.
St. Paul, MN 55113
www.nwc.edu

651.631.5323
image001.jpeg


#10

This is in 10.5 I think.

Michael
image001.jpeg


#11

OK, if anyone following this thread has the beta, give it a try and let me know.
image001.jpeg