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
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.
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.
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_.
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_.
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
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
