Send in them ideas for new Toad features of fixes. Another 27 hours and then
I’ll pick the winner. And good news - I found some extra books, so much more
than three winners 
Bert Scalzo
Database Expert
Bert’s homework is almost due and he needs more ideas for Toad 11 
Then where is the SQL201 question?
Best regards,
Mike
Michael S. Zarzycki, MTS | Manager of Engineering IT | Sensata Technologies,
Inc. | voice: 508-236-1015 | fax: 508-236-3701 | www.sensata.com | The World
Depends on Sensors and Controls
I’m still looking for code staples to appear in the printing of long
code…please?
In all seriousness, there is something I encounter occasionally when writing SQL
code that would be a cool editor feature. The ability to mark a list of values
separated by spaces, commas, or CRLFs, and execute a function that will wrap the
list with parens, place single quotes around each value, and delimit the values
with commas, the latter function being ignored if already delimited that way.
Ideally, the last value in the list won’t have a trailing comma.
Who knows? Toad is so feature-rich, maybe it can already do that.
Best regards,
Mike
Michael S. Zarzycki, MTS | Manager of Engineering IT | Sensata Technologies,
Inc. | voice: 508-236-1015 | fax: 508-236-3701 | www.sensata.com | The World
Depends on Sensors and Controls
Guys - you have to email me offline the ideas - I am not taking them from the
yahoo group - bert.scalzo@quest.com
You can get pretty close to this with regular expressions.
Assuming your list is…
THIS IS A TEST
Just search for… \s+ and replace with… ‘, ‘
You’ll just need to add your leading and trailing quote. I think that
features like these are part of the reason that Toad is so bloated.
Michael
Hey, one man’s bloat is another man’s treasure J
I tend to go the select ‘…’ || ‘…’ ||
… route myself for this kind of stuff, but if I knew regex like I should,
that would be the way to go
If bloat is a problem, why are we being asked to provide feature suggestions?
I’m not necessarily looking for new items for the main menu - but rather the
little nice to haves that people run into every day. For example something as
simple as make all screens that offer wildcards consistently use both * and *
the same way. Nothing earth shattering - but rather true productivity enhancers
- not bloat
Very good idea.
I am using TextPad for now, it does it for me.
You can do this with make code / strip code in Toad. We ship some predefined
language templates, but you can add your own - and you can define whatever you
want to make it do …
And those winners would be……???
Darlene R. Ulmet
Financial Analyst II
Decision Support Services
Baylor Health Care System
Phone: (214) 820-1936
Fax: (214)820-8284
Email: Darlene.Ulmet@BaylorHealth.edu
All the ideas and my selections will be posted in my blog this week (should up
up Tues or Wed on ToadWorld).
The winners have already been sent an email. Remember, the winners were just
Bert’s suvbjective favorites - that does mean any idea was bad, just that some
caught my faancy more than others. I looked for mostly minor enhancements to
existing features that would make people more productive - and most of those
fell into simple editor type stuff since that’s the bulk of what people do in
Toad (i.e. edit code) …
There were six winners - and not three. I’m sure some people won’t like my
choices - but it does not mean anything as far as TOAD goes - just my personla
likes was all for free books.