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