Toad World® Forums

Multi-line data in TOAD 10 data grids

Hi folks,

Prior to TOAD 10, if a cell in a data grid contained multi-line data
it would be shown in the grid with the new lines converted to spaces.

e.g. the data ‘Hello’ || CHR(10) || ‘World’ would look like

Hello World

in the grid.

However, in TOAD 10 grids we just see Hello and need to double-click
to see the rest of the data.

Not a massive problem obviously but something I found useful in the
previous versions. For example when scanning through an error logging
table it now just shows the first line in the error stack whereas
before subsequent lines were also visible. Would it be possible to re-
enable this functionality please?

Cheers,

Kevin.

Fixed for Toad 10.5. I see it displaying your example as “HelloWorld” though, not “Hello World” so if you are seeing it with a space then send me your INI in case there is an option controlling that. I’ve made it display as “HelloWorld” which is what I see in 9.7.

Michael

A quick follow-up: We are applying this fix to the December patch as well.

Michael

To clarify, Michael, does the “HelloWorld” you’ll be displaying have the
goofy but extremely helpful and necessary graphic box dividing the words as
in 9.7? My emailer doesn’t show it.

Rich – [TeamT]

Disclaimer: Subtle. Veeeerrrrry subtle.

A quick follow-up: We are applying this fix to the December patch as well.

Michael

Fantastic - thanks a lot.

I probably just imagined there was a space - that’s great as you described it
:slight_smile:

Cheers,

Kevin.

On 3 Nov 2009, at 14:50, Michael Staszewski wrote:

A quick follow-up: We are applying this fix to the December patch as well.

Michael

What is your grid font in 9.7? I am only seeing “HelloWorld” No graphics, boxes, or other characters that would indicate that anything at all is present between Hello and World. Copying to clipboard does correctly include the newline character though.

Michael

Just checked in 9.7, I too was getting square boxes. Grid data font - Tahoma,
Regular, 7.

On 3 Nov 2009, at 15:11, Michael Staszewski wrote:

What is your grid font in 9.7? I am only seeing “HelloWorld” No graphics,
boxes, or other characters that would indicate that anything at all is
present between Hello and World. Copying to clipboard does correctly include
the newline character though.

Michael

Tahoma, Regular, 8. Eight!??? SEVEN!??!? There was time not too long ago,
where I was the one with the unbelievably tiny font.

Where’s those carrots I brought for lunch?

Rich – [TeamT]

Disclaimer: Carrots are divine, you get a dozen for a dime, it’s maaaaagic.

Just checked in 9.7, I too was getting square boxes. Grid data font -
Tahoma, Regular, 7.

Can you send me your INI offline? I am using Tahoma 8 and not seeing squares in
9.7. I am testing with your example executed as follows…

SELECT ‘Hello’ || C HR(10) || ‘World’ FROM DUAL

Please make sure that it is the 9.7 INI if you still have it.

Thanks,

Michael

For what it’s worth, in both 9x and 10 I don’t see any special character; all i see is ‘Hello’ and need to open the popup to see the new line. I would guess that maybe it is the language or character set that determines this behavior instead of the font. I’d actually like an option to show special characters in the data grid like you can in the editor; or maybe highlight the cell that has a special character like you can with a null.

Hi Toad Team

i would like to tell u guys something that is not so cool about
your grid

Few month ago i downloaded new toad 10 with hope there might be
some new feature and some fixes that solve crashes problems.

But my hope piss off when i tried to enter data in date field in new grid i was hackle by knowing
it was not taking my date in DD/MM/YYYY format

i also read out help and found that it takes only in MM/DD/YYYY format
it is too much

in previous versions i even enter it in dd-MMM-YYYY format

so pls look in to matter and solve this fast in new build

Are you running the latest patch version of Toad 10? 10.1.1.8?

Bump. I use Toad for MySQL, which is basically the same code as Toad for everything else.

I also want to see a little better indication in the grid when data has newlines. A lot of our data has rather variable line lengths, so often all I see in the grid is a short first line and a column which width Toad has re-sized way off the screen, so if I scroll horizontally may see nothing at all in the column – not useful. Maybe the other lines can be shown delimited somehow on the same line, in a lighter color maybe…?

And when I edit the data via the grid, now I see all the lines, but in a huge text dump delimited with those funny graphic boxes – again less than useful.

If anything, the grid and editor newline behavior should be reversed – the grid might show the funny newline boxes in one giant dump, and the editor should show the data with actual friendly line separations.

At least an option for such would be helpful.